Search found 3 matches

by ninudvictor
Fri Feb 27, 2009 8:57 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Need Help in Updating with Current Timestamp
Replies: 2
Views: 7321

Need Help in Updating with Current Timestamp

Hi All, I am trying to update a column(CARD_TS,26 bytes length) of a table with Current Timestamp from a Cobol program by calling a subprogram which has the required query to update the table. I am using "FUNCTION CURRENT-DATE" (21 BYTES) which gives timestamp like "200902260845+0000". The last 5 by...
by ninudvictor
Thu Nov 20, 2008 9:32 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Need Help for a Sort Card
Replies: 1
Views: 3860

Need Help for a Sort Card

Hi All, I have a PS file of length 1066bytes. It is having Header Record then Detail Records and then Footer. The Header Layout is- AHDRDMD8400 YYYYMMDD i.e. In Heade Record- Pos 1- Header REC-ID = 'A' Pos-2 to 4 - Header ID = 'HDR' Pos-5 to 12-Dataset ID= 'DMD8400 ' Pos-13 to 20-Date= `YYYYMMDD' I ...
by ninudvictor
Mon Oct 20, 2008 9:14 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 COMMIT??
Replies: 1
Views: 9547

DB2 COMMIT??

Hi All, I am doing UPDATE in two tables in a single program (Program with Checkpoint Restart Logic). I want to commit the changes after processing five records.So is it reuired to mention two COMMIT to save the changes in two different table? My question is - If there are 'n' no. of tables to be upd...