Search found 186 matches
- Fri Feb 06, 2015 7:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: yyyyy-mm-dd to DD/MM/YYYY
- Replies: 8
- Views: 8276
- Wed Feb 04, 2015 11:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: yyyyy-mm-dd to DD/MM/YYYY
- Replies: 8
- Views: 8276
- Wed Feb 04, 2015 9:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: yyyyy-mm-dd to DD/MM/YYYY
- Replies: 8
- Views: 8276
yyyyy-mm-dd to DD/MM/YYYY
Hi,
Any idea how do I convert yyyyy-mm-dd to DD/MM/YYYY in server jobs.
Source column is Timestamp and output column is DATE.
Any thoughts.
Thanks,
Any idea how do I convert yyyyy-mm-dd to DD/MM/YYYY in server jobs.
Source column is Timestamp and output column is DATE.
Any thoughts.
Thanks,
- Thu Jun 26, 2014 7:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance stats and no. of rows in source does not match
- Replies: 7
- Views: 5820
- Wed Jun 25, 2014 12:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance stats and no. of rows in source does not match
- Replies: 7
- Views: 5820
Performance stats and no. of rows in source does not match
Hi, Got a job Oracle stage -> Hash file When I compile the job and run, it gives me the no. of rows processed as 256, but sometimes, it shows me no of process as 20 rows only, when run from sequencer. In the source no. of rows are 256. No error logs or warning coming. In the Oracle stage it's a simp...
- Thu Feb 27, 2014 10:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to check the datetime format
- Replies: 11
- Views: 5294
- Wed Feb 26, 2014 3:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to check the datetime format
- Replies: 11
- Views: 5294
- Wed Feb 26, 2014 2:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to check the datetime format
- Replies: 11
- Views: 5294
Need to check the datetime format
Hi Guys, Need to check the format of the incoming values is YYYY-MM-DD HH:MM:SS.XXX I need to find the last 3 digits i.,e XXX if it exists I need to take the left 19 digits. My source is SQL server and column is Nvarchar and the output column is also nvarchar. 2011-07-01 00:00:00.000 2010-10-05 00:0...
- Mon Feb 24, 2014 1:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to add blank/empty line at the end of the file
- Replies: 11
- Views: 6628
- Fri Feb 21, 2014 5:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to add blank/empty line at the end of the file
- Replies: 11
- Views: 6628
- Fri Feb 21, 2014 5:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to add blank/empty line at the end of the file
- Replies: 11
- Views: 6628
Hi, Have tried the option of awk Without the awk command, iam getting the below output. Job_No;65 # 1 blank line Sequence[1;2] Job_no;1 With the awk command, iam getting the below output. Job_No;65 # 1 blank line # 2nd blank line is coming Sequence[1;2] Job_no;1 #Blank line is coming How to remove t...
- Fri Feb 21, 2014 5:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to add blank/empty line at the end of the file
- Replies: 11
- Views: 6628
- Fri Feb 21, 2014 5:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to add blank/empty line at the end of the file
- Replies: 11
- Views: 6628
Need to add blank/empty line at the end of the file
Hi Guys, Need 1 help to generate a blank line in the output file at end. Job desgin External_source_1 External_source_2 -> Funnel -> Sequential Stage Row_Generator Iam getting the output, the only issue is need a blank line in the output file at the end. Any help would be appreciated. Thanks,
- Tue Feb 18, 2014 11:39 pm
- Forum: General
- Topic: Error while exporting folder
- Replies: 3
- Views: 3630
- Thu Feb 06, 2014 4:34 pm
- Forum: General
- Topic: Error while exporting folder
- Replies: 3
- Views: 3630
Error while exporting folder
Hi Guys, Please need your help, while exporting a Folder from the Export option, Iam getting the below error. An unhandled exception has occurred in a component in your application. Click continue and application will ignore this error and attempt to continue. Object reference not set to an instance...