DSXchange

Of top of my head...what i can suggest is

Convert your input date in Internal Format through Iconv
and then convert that to Julian..through Oconv.

What is the format of your input Date ?

Do you have enough space in disk ?

Hey what does it say when you click MORE ? Can you please check

After you got compilation error, Did you click on more and see what it says ?

You can release from Director only if you have Admin rights....the other option is once u get the PID you can Kill that Process from Unix.

Regards

Use ICONV to convert the Julian Date into DataStage internal format..and then use OCONV to convert into the format you want.

regards

How about comparing key columns and running, CRC32 on Non key columns. The best way would be Unix Cmp or Diff command...if files.

Regards

Is there anyway i can get date added in my file name. One way is if i have date in my parameter..can I assign it dynamically ?

But Ray, doesn't that mean that one will end up using more number of transformer..or will end up creating multiple jobs, with job dependency ??

Is there any way by which one can reset the hash file using routines?

Hi Siva,

Can you throw more light on this. Whats VOC? and where should i write this command ?

Thanks Again

Can anyone tell me how to reset surrogate key generated using Keymgmt function in Datastage.

Thanks in advance

Hello,

I am using DSGetLinkInfo routine to get link info of my job, but somehow i am getting -1 in the read count. Does anyone know y is that ?

I have a job in which I m calling this routine to find link info for another job. in this routine i m passing the job name plus the other info.

Thanks

Hello All, Can anyone tell me why this error occurs ? [IBM][CLI Driver][DB2/AIX64] SQL0973N Not enough storage is available in the "APP_CTL_HEAP_SZ" heap to process the statement. SQLSTATE=57011 And whats the solution ?? Basically, I am using an DB2 API stage to join few tables as a source.