DSXchange

You mean KBATimestampDeltaSecondsroutine.

Export your SharedContainer. Make a copy for backup. Open the file. Replace all occurances of Readonly "1" to Readonly "0". Re-import the shared container.

Are the two dates in timestamp format ? You can certainly write a routine. Extract the date part, get the internal format which is number of days, multiply that with 24*60*60 to get number of seconds. Add that to the ICONV of time which will be number of seconds since Jan 1st 1968 12:00 AM. Get both...

I am sorry I didnt get you, what was your problem again and how did you fix it?

ArndW's way is infact the simplest and error free.

What command did you run?

Sure you can. Do a Null check on the incoming record and if Null is found, change it to an empty character.

You need to set your dsenv first. Search on how to execute dsenv file. Then run that command. Or simply log onto your DataStage Administrator and run the commad

in the command area. Dont forget the trailing semicolon.

I do, buts its a hack, the seond method that I noted. I would still wait for someone else to come along and explain you how its done. Patience my friend

kduke wrote:Routines have to be done manually. Shared container for some reason get exported along with the job.

Thats what I wanted to confirm. Was really hoping for a different answer but o well, limitations are present.
Thanks Kim.

Explicitly allocate memory for your variable inside the routine and then free it after making the return call. char* retValue = (char *)malloc (sizeof(char *)); ----- ---- ----- return retValue; free(retValue) And as for the unexpected results. I think your need to us...

You can export the shared container and import it again using Version Control. In VC it gives you the option of making object read only. Uncheck that option. The other way you be to go into the internal repository table DS_CONTAINERS and update your shared container. FOr that you will be needing the...

It seems like Ray can sense machine vibes

Or maybe a C function which has all different conditons in a Case statement.

Kim, you script can also export routines?