Search found 3 matches
- 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...
- 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 ...
- 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...