Search found 133 matches
- Sun Jul 15, 2018 6:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Issue with ODBC connecor in Server Job
- Replies: 1
- Views: 12684
Issue with ODBC connecor in Server Job
Hi All, We have a job design in server where the same table is reading and writing and then reading, in 9.1 server we have a sparse lookup with ODBC enterprise stage with transformer but before that the same table will be writing the data and the written data is extracting in the next stage. But whe...
- Thu Apr 12, 2018 10:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Issue w/ multiple Insert statements running parallel in ODBC
- Replies: 1
- Views: 13490
Issue w/ multiple Insert statements running parallel in ODBC
Hi All, 9.1 datastage version we have designed one job which will have multiple insert statements in ODBC enterprise stage in Server job which is executing successfully. But when we tried to migrate the same job to 11.5 and replacing ODBC enterprise stage with connector and triggered the job but ODB...
- Thu Jun 08, 2017 2:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: xml input stage not reading new xml file
- Replies: 2
- Views: 2915
xml input stage not reading new xml file
Hi , I am getting a very weird issue when using xml file. My xsd has the pattern value as <xs:pattern value="[a-zA-Z \-]*"/> (size 40) which accepts a to z letters capitals and smaller plus '-' in between the word. My New xml file having item code like 'Honda-model-B' which is throwing enu...
- Tue Oct 18, 2016 3:52 am
- Forum: General
- Topic: Not able to Fetch latest log for Multi instance job
- Replies: 1
- Views: 2318
Not able to Fetch latest log for Multi instance job
Hi All,
I am writing command (dsjob -lognewest <ProjectName> <DSJobName>.<InvocationID>) to get the latest log but when I trigger multiple jobs in parallel, log is extracting from main job not from the invocation job. Can you suggest what needs to be changed here.
I am writing command (dsjob -lognewest <ProjectName> <DSJobName>.<InvocationID>) to get the latest log but when I trigger multiple jobs in parallel, log is extracting from main job not from the invocation job. Can you suggest what needs to be changed here.
- Fri Oct 14, 2016 1:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML with multiple header and body in a single file
- Replies: 6
- Views: 6062
- Thu Oct 13, 2016 4:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML with multiple header and body in a single file
- Replies: 6
- Views: 6062
- Wed Oct 12, 2016 7:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML with multiple header and body in a single file
- Replies: 6
- Views: 6062
You need to fully release the xml for each group of incoming rows that define a whole body. Set up a sort key and put the incoming rows in the order by each desired body and then use trigger column ... I tried it, but i am still not getting the proper result. Below is my understanding, Please clari...
- Wed Oct 12, 2016 1:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML with multiple header and body in a single file
- Replies: 6
- Views: 6062
XML with multiple header and body in a single file
Hi, I have a requirement to create a single XML output file with multiple headers. For example, if I have 3 records coming to my XML stage, then I need to have header for each record. Sample expected output format below. <?xml version="1.0" encoding="UTF-8"?><TCRMService xmlns=&q...
- Wed May 04, 2016 6:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregation and fetch values based on the logic
- Replies: 2
- Views: 3675
Aggregation and fetch values based on the logic
Hi All, I have requirement that group by ID field fetch the value from Current Location/Current Role based on the Maximum date, if value is blank for the maximum date then fetch the previous date value and so on. And fetch the value from Previous Location/Previous Role based on Minimum date, if valu...
- Thu Apr 07, 2016 4:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivoting scenario in parallel job
- Replies: 4
- Views: 3422
- Wed Apr 06, 2016 12:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP not working for Salesforce Server Package stage
- Replies: 6
- Views: 8804
RCP not working for Salesforce Server Package stage
Hi All, I am trying to fetch the data from SOQL Database using sales force connector server Package. When I tried to define column metadata I can see data in dataset but when I use RCP without defining columns Job is getting successful but in dataset all values are coming as blank. Anyone knows the ...
- Thu Mar 10, 2016 11:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unique records into single line
- Replies: 4
- Views: 3509
- Thu Mar 10, 2016 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unique records into single line
- Replies: 4
- Views: 3509
Unique records into single line
Hi All, Below is my source file format. Account name,city,value ABC,hyd,1000 DEF,ban,2000 ABC,Chn,3000 GHI,US,3000 JKL,UK,4000 DEF,us,6600 I need to find unique records I. Account name column and all unique records to populate in single line like below. Output: /'ABC/',/'DEF/',/'GHI/',/'JKL/' Please...
- Wed Feb 17, 2016 3:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CurrentDate() Year extract
- Replies: 4
- Views: 5992
- Wed Feb 17, 2016 3:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: input Column 0 value to NULL in target
- Replies: 4
- Views: 3300