Search found 134 matches
- Tue May 01, 2018 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise Stage Hung
- Replies: 1
- Views: 1958
FTP Enterprise Stage Hung
Hi All, Recently we migrated from 8.7version to 11.5version of datastage. in 11.5 we could see FTP job getting into hung state, job has only sequential file stage and then FTP enterprise stage with Ascii / FTP transfer mode. Target server is IBMi. This FTP job is a common job and is used by many ins...
- Mon Jun 26, 2017 4:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Comparison between group of input and Reference Records
- Replies: 5
- Views: 3281
- Sun Jun 25, 2017 9:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Comparison between group of input and Reference Records
- Replies: 5
- Views: 3281
Date Comparison between group of input and Reference Records
Hi Team, I need some help in doing this date comparison logic for the given input and reference file. For the grouping rows on Column1 and Column2, i need to compare the from date and term date in input file with the reference file From date and Term Date. If the input file From date and Term date i...
- Wed Jun 07, 2017 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Compile Issue - Stage variable
- Replies: 0
- Views: 2534
Datastage Compile Issue - Stage variable
Hi Team, I am getting the below error message while compiling the job, This is happening only in DEV environment, the same job compiling fine in other enviorments... I tried to delete the job in dev and imported again, still same issue. While debugging, 1. I tried to remove all the stage variables a...
- Mon Dec 05, 2016 4:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Chinese/Japanese - View Data issue in Datastage
- Replies: 6
- Views: 4190
- Thu Dec 01, 2016 4:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Chinese/Japanese - View Data issue in Datastage
- Replies: 6
- Views: 4190
- Thu Dec 01, 2016 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Chinese/Japanese - View Data issue in Datastage
- Replies: 6
- Views: 4190
Chinese/Japanese - View Data issue in Datastage
Hi Team, Currently I am working on the POC to read/Write the Chinese/Japanese data from oracle table into the Target Oracle/Teradata Table and Seq File using the datastage jobs. Source data in oracle looks good and the target data in Oracle/Teradata table also looks good. The Target file while viewi...
- Wed Jul 15, 2015 4:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal_From_Decimal Warning Issue
- Replies: 2
- Views: 2602
Decimal_From_Decimal Warning Issue
Hi All, I am extracting the data from Oracle and loading into Teradata Database. In oracle I have the datatype as decimal(38,10) but in Teradata it is decimal(9,4) only as confirmed by DBA and they recommend to Round off the decimal points in TD. I am using the DecimalfromDecimal with round_inf opti...
- Mon Jun 22, 2015 3:33 pm
- Forum: General
- Topic: Teradata Conn Stage - Designer Crashes while editing TDCon
- Replies: 8
- Views: 3641
- Mon Jun 22, 2015 1:19 pm
- Forum: General
- Topic: Teradata Conn Stage - Designer Crashes while editing TDCon
- Replies: 8
- Views: 3641
Teradata Conn Stage - Designer Crashes while editing TDCon
Hi Team, I am having the Datastage Client V 9.1.2.b installed on my machine Windows 7. While editing the properties of teradata connector stage, particularly on the Error Table properties, Designer crashes and am not able to edit that. I tried editing the stage from already existing jobs still havin...
- Wed Nov 28, 2012 12:37 am
- Forum: General
- Topic: Dsjob cmd to retrieve Job annotation, Job Short/longdescrptn
- Replies: 4
- Views: 2383
Dsjob cmd to retrieve Job annotation, Job Short/longdescrptn
Hi Friends, I would like to know how to retrieve the Job Annotation and Job Description using dsjob command. I have around 500 jobs ..I need to validate whether the job annotation and job description is missing in any of the job. I tried with all the commands in Dsjob, but i could not get the above ...
- Mon May 14, 2012 5:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic transformer usage issue in Parallel job
- Replies: 1
- Views: 1742
Basic transformer usage issue in Parallel job
Hi All, I have a parallel job like below using the Basic transformer to call the Routine in derivation. Seq file ------Basic Transformer-------Seq File Inside the Basic transformers derivation am using the Basic routine. While running ,the job aborts with the below issues warnings: library dsjobsh f...
- Tue May 08, 2012 12:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Director Job Monitor Status Shows Unknown
- Replies: 4
- Views: 2811
- Mon May 07, 2012 3:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Director Job Monitor Status Shows Unknown
- Replies: 4
- Views: 2811
Director Job Monitor Status Shows Unknown
Hi Friends, While viewing the job monitor from the Director, for all the stages the status is shown as Unknown and the Num rows is 0. But the job is successfully completed. But the coresponding sequence aborts as it gets the link count from the job which completed with status Unknown. We tried resta...
- Wed Jul 06, 2011 6:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup Issue
- Replies: 1
- Views: 1475
Lookup Issue
Hi Team, I am doing simple lookup b/w source and reference using Lookupstage. My source has column as col1 varchar(255) -> value = Product group category My reference has column as abc varchar(20) -> value = Product group cate I am doing a lookup between this two columns and taking some column out f...