Free software training Videos

Free software training Videos
https://www.youtube.com/user/VLRTraining

List Of Best WebSites

Sunday 30 December 2012

inserting data INto physical file USING SQL

Start the sql interface
in command prompt type strsql command.
***************************************************************************
                           Work with Members Using PDM                 PUB1    
                                                                               
 File  . . . . . .   MYDDS                                                     
   Library . . . .     CHVRAMESH2           Position to  . . . . .             
                                                                               
 Type options, press Enter.                                                    
  2=Edit         3=Copy  4=Delete 5=Display       6=Print     7=Rename         
  8=Display description  9=Save  13=Change text  14=Compile  15=Create module...
                                                                               
 Opt  Member      Type        Text                                             
      PF001       PF          my pf file                                       
      STUDENT     PF          student physical file                            
      STUDENT1    PF          student physical file unique                     
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                         Bottom
 Parameters or command                                                         
 ===> STRSQL                                                                   
 F3=Exit          F4=Prompt             F5=Refresh            F6=Create        
 F9=Retrieve      F10=Command entry     F23=More options      F24=More keys    
****************************************************************88

this screen will open
============================================================
                             Enter SQL Statements                            
                                                                             
Type SQL statement, press Enter.                                             
   > SELECT * FROM STUDENT1                                                  
     SELECT statement run complete.                                          
   > SELECT * FROM STUDENT                                                   
     SELECT statement run complete.                                          
     Session was saved and started again.                                    
     Current connection is to relational database PUB1.                      
===>   ----------------------------------------
------------------------------------------------------                                                                      
                                                                             
                                                                             
                                                                             
                                                                             
                                                                             
                                                                             
                                                                             
                                                                             
                                                                             
                                                                             
                                                                       Bottom
F3=Exit   F4=Prompt   F6=Insert line   F9=Retrieve   F10=Copy line           
F12=Cancel            F13=Services     F24=More keys                          
=====================================================
insert into student1 values('ramesh','ece','5678',9898987654)
press enter
 > insert into student1 values('ramesh','ece','5678',9898987654)   
   1 rows inserted in STUDENT1 in CHVRAMESH2.                      
=====================
now type select * from student1

the out put is
                                  Display Data                                 
                                              Data width . . . . . . :      62 
 Position to line  . . . . .              Shift to column  . . . . . .         
 ....+....1....+....2....+....3....+....4....+....5....+....6..                
 NAME                    BRANCH      CARDNO              PHONE                 
 ramesh                  cse         23413       9,999,999,999                 
 ramesh                  it          54321       9,999,999,996                 
 ramesh                  ece         5678        9,898,987,654                 
 ********  End of data  ********                                                


No comments:

Post a Comment