Search found 199 matches
- Tue Aug 11, 2015 11:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML input stage
- Replies: 5
- Views: 3251
- Tue Aug 11, 2015 10:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML input stage
- Replies: 5
- Views: 3251
XML input stage
source xml : <?xml version="1.0" encoding="UTF-8" ?> <root> <ID>1</ID> <ID>2</ID> <ID>3</ID> <UIS>Yes</UIS> <UIS></UIS> <UIS>Yes</UIS> <clubColor>red</clubColor> <clubColor>blue</clubColor> <clubColor>yellow</clubColor> <playerName>Josh R</playerName> <playerName>Jeff K</playerNa...
- Mon Aug 10, 2015 5:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML input stage
- Replies: 5
- Views: 3251
XML input stage
Hi Friends I am reading an xml file using sequential file-->xml_input---> sequence file Job is running fine but the out put is like all the records are identical I have 422 records in the xml file(source) and when I run this job I get 1 single record repeated 422 times. Any suggestions where I am fa...
- Thu Jul 16, 2015 6:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Target stage oracle
- Replies: 4
- Views: 2607
Target stage oracle
Hi Team, I am updating bunch of records in the target but I want to use my own sql to update records using LIKE operator. Can any one help with the syntax. SKU_ID is the key and the below syntax doesnt work if I give in the target stage connector/enterprise stage. UPDATE SKU SET SECONDARY_DESC=:SECO...
- Tue Jul 14, 2015 2:58 pm
- Forum: General
- Topic: Purged logs in datastage
- Replies: 2
- Views: 1744
Purged logs in datastage
Hi
Can anyone let me know if we can retrieve purged logs in datastage.
Currently my project has purge log before 10 days.
Please let me know if there is a way to retrieve.
Can anyone let me know if we can retrieve purged logs in datastage.
Currently my project has purge log before 10 days.
Please let me know if there is a way to retrieve.
- Thu Nov 28, 2013 12:11 am
- Forum: General
- Topic: Passing parameter with spaces to Execute Command Stage
- Replies: 12
- Views: 7605
- Thu Nov 21, 2013 11:29 pm
- Forum: General
- Topic: Passing parameter with spaces to Execute Command Stage
- Replies: 12
- Views: 7605
- Wed Nov 20, 2013 10:21 pm
- Forum: General
- Topic: Passing parameter with spaces to Execute Command Stage
- Replies: 12
- Views: 7605
- Tue Nov 19, 2013 10:16 pm
- Forum: General
- Topic: Passing parameter with spaces to Execute Command Stage
- Replies: 12
- Views: 7605
- Tue Nov 19, 2013 5:26 am
- Forum: General
- Topic: Passing parameter with spaces to Execute Command Stage
- Replies: 12
- Views: 7605
Passing parameter with spaces to Execute Command Stage
I am using an execute command stage passing some parameters
example: Overtime Reporting/Cubes
but my shell script is recognizing only Overtime instead of Overtime Reporting/Cubes value. Can any one help me on how to pass the parameters which has spaces in it?
example: Overtime Reporting/Cubes
but my shell script is recognizing only Overtime instead of Overtime Reporting/Cubes value. Can any one help me on how to pass the parameters which has spaces in it?
- Thu Nov 14, 2013 3:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cognos cube build through Datastage
- Replies: 1
- Views: 1923
Cognos cube build through Datastage
Hi Friends, I am trying to build a cognos 10 cube through datastage , The cube builds cuccessfully but the time stamp on the cognos for the cube doesnt showup updated. I have used the below command can any one help me on this -l #ud_Cognos_user# #ud_Cognos_server# abc/cbd/exec_profile.sh abc/cbd/cub...
- Thu Oct 18, 2012 12:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null value on accessor interfacing to field
- Replies: 1
- Views: 1649
Null value on accessor interfacing to field
Null value on accessor interfacing to field "OPERATOR_CD" This field is coming from source which is nullable yes and I am moving to the output link in atransformation which is also null yes. I assume this is because I need to include code in the code nullto emapty or ifisnull set null .How...
- Wed Mar 14, 2012 1:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ADD date to target files
- Replies: 3
- Views: 3270
ADD date to target files
Hi Team,
I am writing data to files and I want to append sysdate to target filenames is there any easy way who can help me out.
Thanks
I am writing data to files and I want to append sysdate to target filenames is there any easy way who can help me out.
Thanks
- Mon Mar 12, 2012 11:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 9
- Views: 6181
Hi Thanks that resolved my problem in accessing xml file but now I am not able to read more than 1 file in a single run. I have selected the option in external source is Source Method = Specific programs Source program = ls E:\ EMP*.xml I want to read all the xml files that start with EMP in a singl...
- Sun Mar 11, 2012 11:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 9
- Views: 6181
XML Input stage
Hi Team, I am trying to read an xml file using XML input stage. My job design is Job design: External source-->XML_Input--->SEq file Settings: External source: ========== Properties: source Method: Specific program(s) Source program: ls C:\EMP_FILE_Job_Details.xml Format: Record type :Implicit Delim...