Search found 48 matches
- Wed Apr 27, 2016 11:01 am
- Forum: General
- Topic: Subtract Hours from Current Timestamp
- Replies: 7
- Views: 4902
- Wed Apr 27, 2016 10:59 am
- Forum: General
- Topic: Subtract Hours from Current Timestamp
- Replies: 7
- Views: 4902
- Tue Apr 26, 2016 4:22 pm
- Forum: General
- Topic: Subtract Hours from Current Timestamp
- Replies: 7
- Views: 4902
- Tue Apr 26, 2016 4:07 pm
- Forum: General
- Topic: Subtract Hours from Current Timestamp
- Replies: 7
- Views: 4902
Subtract Hours from Current Timestamp
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.
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.
Get Date
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!
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!
- Thu Mar 10, 2016 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: nzload
- Replies: 0
- Views: 2196
nzload
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.
- Thu Mar 10, 2016 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error writing to named pipe
- Replies: 5
- Views: 5948
- Thu Mar 10, 2016 9:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error writing to named pipe
- Replies: 5
- Views: 5948
- Wed Mar 09, 2016 10:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error writing to named pipe
- Replies: 5
- Views: 5948
Error writing to named pipe
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...
- Fri Feb 19, 2016 1:09 pm
- Forum: General
- Topic: Get the month
- Replies: 15
- Views: 7958
- Fri Feb 19, 2016 12:39 pm
- Forum: General
- Topic: Output of shell command in email notification
- Replies: 4
- Views: 2910
- Thu Feb 18, 2016 1:25 pm
- Forum: General
- Topic: Output of shell command in email notification
- Replies: 4
- Views: 2910
Output of shell command in email notification
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...
- Sun Jan 24, 2016 1:53 am
- Forum: General
- Topic: Get the month
- Replies: 15
- Views: 7958
- Sat Jan 23, 2016 8:26 pm
- Forum: General
- Topic: Get the month
- Replies: 15
- Views: 7958