Author |
Message |
Topic: db2 date to julain date conversion |
blitz
Replies: 7
Views: 14829
|
Forum: Application Programming Posted: Tue Jan 23, 2007 9:35 am Subject: db2 date to julain date conversion |
Thanks a lot Kolusu. That is a very good solution. I came across both the functions while going through the manuals, but it never came across me to use a combination like that.. And next time, I'll ma ... |
Topic: db2 date to julain date conversion |
blitz
Replies: 7
Views: 14829
|
Forum: Application Programming Posted: Mon Jan 22, 2007 11:57 pm Subject: db2 date to julain date conversion |
Is there anything in z/OS cobol to map julian dates to db2 iso date format? |
Topic: How to list members of PDS? |
blitz
Replies: 7
Views: 8270
|
Forum: TSO and ISPF Posted: Wed Jan 17, 2007 9:19 am Subject: How to list members of PDS? |
//JS10 EXEC PGM=IEHLIST
//SYSPRINT DD SYSOUT=*
//DDNAME1 DD UNIT=3390,VOL=SER=SYSRES,DISP=OLD
//SYSIN DD *
LISTPDS DSNAME=SYS1.LINKLIB,FORMAT,VOL=3390=SYSRES
/*
Use a IDCAMS LISTC ... |
Topic: Query on Cursors |
blitz
Replies: 6
Views: 2746
|
Forum: Application Programming Posted: Wed Jan 17, 2007 8:48 am Subject: Query on Cursors |
Note of caution: Hope that your 'update' cursor does not involve joins, ORDER BY, etc .. because UPDATE CURSOR wouldn't work in that case. Read this link for more,
http://publib.boulder.ibm.com/inf ... |
Topic: Query on Cursors |
blitz
Replies: 6
Views: 2746
|
Forum: Application Programming Posted: Wed Jan 17, 2007 8:37 am Subject: Query on Cursors |
There is some confusion here. I think the update is on T2. So the 'WITH HOLD', 'FOR UPDATE' should be in C2 cursor.. I agree with Dick on his comments on Commit. |
Topic: Insert/Update a row |
blitz
Replies: 4
Views: 2497
|
Forum: Database Posted: Wed Jan 17, 2007 1:34 am Subject: Insert/Update a row |
If the table to be updated has triggers defined, and you do not want to 'update' if there isn't going to be any change in data, then option '3' is the best way out as options '1' and '2' might trigger ... |
Topic: Insert/Update a row |
blitz
Replies: 4
Views: 2497
|
Forum: Database Posted: Tue Jan 16, 2007 9:41 am Subject: Insert/Update a row |
If the table to be updated has triggers defined, and you do not want to 'update' if there isn't going to be any change in data, then option '3' is the best way out as options '1' and '2' might trigger ... |
Topic: Finding a member |
blitz
Replies: 8
Views: 3469
|
Forum: TSO and ISPF Posted: Tue Jan 16, 2007 5:36 am Subject: Finding a member |
Another note of caution to be taken when using the Member command. Make sure that you have access to all the datasets that are going to be searched. I remember locking my id once for crossing the limi ... |
Topic: A token of immense gratitude for our great moderator. |
blitz
Replies: 13
Views: 17408
|
Forum: About Mvsforums Posted: Mon Oct 09, 2006 11:54 pm Subject: A token of immense gratitude for our great moderator. |
Thanks to the moderators from me too. It is very reassuring to know that people are here to guide you. |
Topic: Multiple Whens in Evaluate |
blitz
Replies: 6
Views: 3070
|
Forum: Application Programming Posted: Tue Jul 11, 2006 6:04 am Subject: Multiple Whens in Evaluate |
AND or OR?!? |
Topic: 'Job postings' |
blitz
Replies: 3
Views: 5006
|
Forum: About Mvsforums Posted: Thu Jan 19, 2006 1:32 am Subject: 'Job postings' |
... and the 'view guestbook' link is not working. I'm getting a 'page not found' error in IE5. New entries are also not being accepted. Getting 'Page not found' again. |
Topic: 'Job postings' |
blitz
Replies: 3
Views: 5006
|
Forum: About Mvsforums Posted: Thu Jan 19, 2006 1:29 am Subject: 'Job postings' |
Forgot to add that there are two Tech FAQ sections now. One on the homepage and another in forums. There should be only one in place. |
Topic: 'Job postings' |
blitz
Replies: 3
Views: 5006
|
Forum: About Mvsforums Posted: Thu Jan 19, 2006 1:26 am Subject: 'Job postings' |
The entries listed are 3 years old. This section ought to be removed. |
Topic: DISPLAY in CICS |
blitz
Replies: 8
Views: 12773
|
Forum: CICS and Middleware Posted: Thu Jan 19, 2006 1:12 am Subject: DISPLAY in CICS |
I got this from a search but the link is not working.
http://www.mvsforums.com/helpboards/viewtopic.php?t=2650&highlight=display |
Topic: vision:report manual. Is it available online ? |
blitz
Replies: 2
Views: 1893
|
Forum: Utilities Posted: Wed Oct 27, 2004 10:15 pm Subject: vision:report manual. Is it available online ? |
superk, thanks for pointing out that thread. |
|