DSXchange

Is removing milli-seconds necessary. I tried replacing '-' with ' '.
Thanks
srikie

How do you declare and assign all fields in the source into your temporary variable? I dint get that part. But here is the stage variable derivation for lastchgdate: if DSLink3.CDB6ED_LAST_CHANGE_C = '0' then '19' || DSLink3.CDB6ED_LAST_CHANGE_YY || '-' || DSLink3.CDB6ED_LAST_CHANGE_MM || '-' || DS...

Hi, My vsam file has date of this 10 CDB6ED-LAST-CHANGE-DT. 15 CDB6ED-LAST-CHANGE-C PIC X(01). 15 CDB6ED-LAST-CHANGE-MM PIC X(02). 15 CDB6ED-LAST-CHANGE-DD PIC X(02). 15 CDB6ED-LAST-CHANGE-YY PIC X(02). which needs to cast to a timestamp attribute of db2 table. When I do it using CAST(LASTCHGDATE AS...

I got that part. But this was another question, can we use 99999999 as 9's complement form of date format?

use keymgmtget next value function to generate the sequence number and character matching can b done using the substring function. hold sequence number in a stage variable so that it cud b copied until the next string with p occurs.

I could see the in the dateformat there is an option '99999999'. Does that mean its in 9s complement format. and if we map it to ccyy-mm-dd. does ascential take care of all the conversion stuff?

I am not sure abt oconv() but one suggestion is extract 'yyyy','mm','dd' and concatenate. I am sure there is much a better way to do this but this was just a quick thought.
srikie

Well, I am not sure if I am allowed to do that (deleting or redefining the format). But thanks for your valuable suggestions.

Hi Sainath My source format is : 20 FM132-SER-NUM-JULIAN-DATE. 25 FM132-SER-NUM-JULDT-CCYY. 30 FM132-SER-NUM-JULDT-CC PIC X(02). 30 FM132-SER-NUM-JULDT-YY PIC X(02). 25 FM132-SER-NUM-JULDT-DDD PIC X(03). Now when I try to change child elements date format according to ccyyddd it gives me error that ...

Sainath.Srinivasan wrote:It needs to go in the 'Date format' of your column defn.

I am sorry I dint get you.

My source file is vsam file. When I try to change the date format for that column bcoz its a group it doesnt give any listing the drop-down list. But when I changed column type from group to character, it gives me the Error: Group column cannot have data type other than GROUP. Error: Maximum file re...

Thanks, actually my source date format is 'CCYYDDD'. Can you tell me how to specify date format for source and target seperately. I can see there is only one date format option available in job properties and it does have 'CCYYDDD'.
Srikie

Hi,
I am working on DS MVS edition. Can any one suggest me on how to convert julian date which is of 'ccyy-ddd' format to 'ccyy-mm-dd'.
As I am working on msv edition I dont have the comfort of using server routines.
Thanks
Srikie

Yeh I did it that way and also I typed manually in table defnition which also dint work. I think Timestamp is supported in flat file stage but what I found out again is its length has to be mentioned 26 we cant leave the length blank like we do it for date.
Thanks
srikie

Mike, Hurraaaaaaaayyyyyy ! :D finally I solved the problem. The problem is with timestamp attribute, I am yet to know wats the problem but when I removed tht attribute, its generating code. Something with flat file and timestamp. If anyone knows any thg abt it please enlighten me. Really hard way to...