|
View previous topic :: View next topic
|
| Author |
Message |
kavya123
Warnings : 1
New User
Joined: 11 Jul 2007
Posts: 34
Location: hyderabad
|
|
|
|
I have created a table using TBCREATE and added some records using TBADD then closed it.
Table was successfully created and saved.
But when i tried to open the table in other member I am getting RC = 8 which says table is not existing.
Can someone help me out!!! |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10872
Location: italy
|
|
|
|
| Quote: |
| Table was successfully created and saved. |
do You trust more Your judgment or the message 
review the create and save part,
check and make god use of the return code information
or said in a more rude  fashion... fix Your program
( edited to lower case, kEyboard stuck ) |
|
| Back to top |
|
|
kavya123
Warnings : 1
New User
Joined: 11 Jul 2007
Posts: 34
Location: hyderabad
|
|
|
|
This is my first program in which i have created,added and saved.
| Code: |
address ispexec
"libdef isptabl dataset id('U153134.REXX.TABLES')"
"tbcreate emp keys(empid) names(name) write share"
say 'rc of create' rc
empid = 1
name = kavya
"tbadd emp order"
say 'rc of add 1' rc
empid = 2
name = sushma
"tbadd emp order"
say 'rc of add 2' rc
"tbclose emp"
say 'rc of close' rc
exit |
i got all RC as '0' and i can see the table EMP created with the records i have added in my PDS.
After that i wrote other code to open the table as follows
| Code: |
ADDRESS ISPEXEC
"LIBDEF ISPTABL DATASET ID('U153134.REXX.TABLES')"
"TBOPEN EMP NOWRITE SHARE"
SAY 'RC OF OPEN' RC
EXIT |
I am getting RC =8. |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| Are ISPTLIB and ISPTABL using the same library? If so, do you see your table actually in the ISPTABL library? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10872
Location: italy
|
|
|
|
Check if Your table library is in Your ISPTLIB concatenation 
the code was right, the setup has to be fixed |
|
| Back to top |
|
|
kavya123
Warnings : 1
New User
Joined: 11 Jul 2007
Posts: 34
Location: hyderabad
|
|
|
|
SuperK,
Could you plaese help me out in seeing the table in ISPTLIB.
How to do that? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10872
Location: italy
|
|
|
|
| same as for isptabl ... LIBDEF ISPTLIB ... ... |
|
| Back to top |
|
|
kavya123
Warnings : 1
New User
Joined: 11 Jul 2007
Posts: 34
Location: hyderabad
|
|
|
|
Thank You Enrico and SuperK
After changing the libdef to ISPTLIB i am able to open the table.
Thanks a ton! |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10872
Location: italy
|
|
|
|
You are welcome  |
|
| Back to top |
|
|
|
|
