Free software training Videos

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

List Of Best WebSites

Showing posts with label STRSQL COMMAND IN AS400. Show all posts
Showing posts with label STRSQL COMMAND IN AS400. Show all posts

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  ********