DSXchange

Thanks Ray, I see AddDaytoTimestamp, nothing with hourly I'll try to see how I can edit one of these and get familiar with building routines, don't have much experience in this area. However, I'm looking for a solution as quick as possible with since my time is very limited.

Hi Craig, what do you mean by underflow?

chulett wrote:TimestampOffsetByComponents() ...

Thanks Craig. How would I get the full result in the desired format?

Also I mentioned I am trying to accomplish this in user variable stage. Does this function work in that stage?

Hello,

I am looking to get the current timestamp minus 5 hours. For example if right now is:

2016-04-26 18:01:15
It will return 2016-04-26 13:01:15

Another example if now is:
2016-04-26 01:01:15
It will return: 2016-04-25 20:01:15

Looking to do this in a user variable stage.

thanks ray

Hello,

Trying to get the date of the most recent Sunday that has past (or if it is Sunday use that date). Deriving this date in a user variable stage.

Would like the output format of the date to be YYYYMMDD.

thanks!

Anyone know how I can use the nzload in DS 11.3? I have been looking for the option everywhere in the Netezza Connector Stage but can't find it.

What's weird is that I didn't see this file increasing in size while the job was running, so I'm wondering if data is transferred into named pipe in one large batch...

I've tried to set it to other directories in thr named pipe location option which should have space but same error. Any other suggestions?

By the way what is the named pipe used for?

I am getting this error message at ~ 4M rows on the target Netezza connectors stage: TargetNetezaStage: Failed to write to named pipe /tmp/server02_49736_nzw_0_1_20160310041042104013. Error code: 32 (CC_NZPipe::write, file CC_NZUnixPipe.cpp, line 321) The setup is Netezza (source) --> Netezza (Targe...

The routine is working very well. Thanks Craig & Ray.

Hi Ray, funny you suggest this as this is exactly what I implemented. I've set up the trigger on whether there was output from my command or not.

Hello, Would like to add the output of a shell execute stage to the body of a notification activity. Currently I have setup as following: Execute Stage ---> Notification Stage Here is an image of the Notification Stage, as you see I am trying to add the command output of the execute stage to the bod...

Thanks Craig, I'll check out the routines ray has posted. I'm newer to datastage and haven't used routines before so something to explore.

Hi chullet, i'm adding in another requirement. So if I want to use a loop to load more than 1 month starting with the previous month then 2 months back, then 3 months back etc.