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