problem in displaying a temporory table with added data



TSO Programming, ISPF, SDF, SDSF and PDF, FTP, TCP/IP Concepts, SNA & SNA/IP etc...

Re: problem in displaying a temporory table with added data

Postby malli419 » Wed Jun 27, 2012 12:29 pm

Thanks NicC,

Yes the temporary table is ispf table it is INVNT701.

Actually in first panel i have some rows in one temporory table INVNT700. User can correct part numbers in that panel.
Once the corrects (for exp) 5 parts i need to check those 5 parts in my DB2 table. Here if the parts found in DB2 table i will update them. if not i need to send those parts to another panel and display them using another temporory temble which is INVNT701.
So as i siad in example if 5 parts are corrected by the user suppose 2 parts are not found in DB2 table i need to display those 2 parts in another panel. My code is displaying 2 parts but the 2 parts are same the 2nd part is displayed in 2 rows of INVNT701.........

Hope it is meaningful.........

Thanks in Advance.
malli419
 
Posts: 13
Joined: Mon Apr 16, 2012 2:25 pm
Has thanked: 4 times
Been thanked: 0 time

Re: problem in displaying a temporory table with added data

Postby malli419 » Wed Jun 27, 2012 2:05 pm

Ya Pedro the names are same in vdefine and panel(MODEL)
malli419
 
Posts: 13
Joined: Mon Apr 16, 2012 2:25 pm
Has thanked: 4 times
Been thanked: 0 time

Re: problem in displaying a temporory table with added data

Postby Pedro » Wed Jun 27, 2012 7:01 pm

the names are same in vdefine and panel(MODEL)

and TBCREATE?
Pedro Vera
User avatar
Pedro
 
Posts: 686
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Re: problem in displaying a temporory table with added data

Postby malli419 » Wed Jun 27, 2012 7:08 pm

Ya pedro it is same even in TBCERATE...the table is displaying the rows but the last row is repeated in all rows....

Thanks in advance
malli419
 
Posts: 13
Joined: Mon Apr 16, 2012 2:25 pm
Has thanked: 4 times
Been thanked: 0 time

Re: problem in displaying a temporory table with added data

Postby Pedro » Wed Jun 27, 2012 9:25 pm

My diagnosis with limited information is that not all of the parts match correctly. Can you show us the actual statement from the )MODEL section. And show us the actual TBCREATE statement.

Also, can you print out PART_NO, U_PART, PART_N, I_PART during each iteration? Are you sure DB2 is returning different data for each iteration. BTW, did you know underscores are not valid in ISPF variable names. Shows us the actual VDEFINE statements also. What return codes do you get from VDEFINE?
Pedro Vera
User avatar
Pedro
 
Posts: 686
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Re: problem in displaying a temporory table with added data

Postby malli419 » Thu Jun 28, 2012 2:50 pm

Hi Pedro,

This is my )MODEL which containes only one field
)MODEL         
+   |PART     


VDEFINE stament is
CALL ISPLINK ('VDEFINE','(PART    )',U_PART         ,'CHAR ',LEN10);


here u_part is program variable

My TBCREATE is
CALL ISPLINK                                                 
   ('TBCREATE', 'INVNT701',' ', PART, 'NOWRITE', 'REPLACE'); 


and coming to DB2 yes it is returning different data in each iteration but when displaying my table i.e.,INVNT701 in eah and every row is shows the last value i mean to say the last retrived part is displayed in all rows............

Thanks..
malli419
 
Posts: 13
Joined: Mon Apr 16, 2012 2:25 pm
Has thanked: 4 times
Been thanked: 0 time

Re: problem in displaying a temporory table with added data

Postby Pedro » Thu Jun 28, 2012 7:05 pm

Is PART a valid PLI program variable?

CALL ISPLINK                                                 
   ('TBCREATE', 'INVNT701',' ', PART, 'NOWRITE', 'REPLACE');


TBCREATE is expecting the names of the table columns. But since 'PART' is not quoted, the compiler will provide the value of the PART variable. ISPLINK will never see that you wrote PART as part of the call.

If PART= 'PART', then you will get what you want, but if it is not, then you get the results you are seeing.

And that is why we ask for the details of all of the calls.
Pedro Vera

These users thanked the author Pedro for the post:
malli419 (Mon Jul 02, 2012 2:56 pm)
User avatar
Pedro
 
Posts: 686
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Re: problem in displaying a temporory table with added data

Postby malli419 » Thu Jun 28, 2012 8:43 pm

Thanks Pedro, i have quoted the part as 'PART' in my TBCREATE now it is working fine and am able to display my temporory table as per the requirement..............

am new to ispf panel still in learning stage anyway thanks a lot for ur intrest shown in my problem

thanks,
mallikarjun
malli419
 
Posts: 13
Joined: Mon Apr 16, 2012 2:25 pm
Has thanked: 4 times
Been thanked: 0 time

Previous

Return to TSO & ISPF

 


  • Related topics
    Replies
    Views
    Last post