Search found 133 matches
- Fri Apr 06, 2018 1:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue in reconciliation
- Replies: 2
- Views: 2209
issue in reconciliation
Hi , Datastage version=8.1.0.0 We have reconciliations job. 1 source file - extracting data using ECC stage . 2 source file - other team drop the file in datastage server. we have many reconciliation jobs. one of reconciliation job had issue. record value is same in both sources , but still reconcil...
- Wed Feb 14, 2018 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple records based on value in column
- Replies: 8
- Views: 6158
- Wed Feb 14, 2018 7:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple records based on value in column
- Replies: 8
- Views: 6158
Multiple records based on value in column
Hi , we are using datastage 8.1. my requirement is : Input is like this customer|Count A|4 B|1 C|2 Based on customer count value , need to generate that many output columns for the same customer. output required as Column1 | Column2 A|1 A|1 A|1 A|1 B|1 C|1 C|1 please help me how to get output as req...
- Sat Jan 13, 2018 2:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: S103268(SAP ID) is not a CPIC-C user
- Replies: 1
- Views: 2280
S103268(SAP ID) is not a CPIC-C user
Hi Teasm , SAP login/password error from Data Stage ABAP Stage, when validating stage in abap stsge , getting error that "S103268 is not a CPIC-C user." Recently SAP login password is changed, while connecting SAP from Data Stage ABAP stage, unable to connect SAP due to above error. Same u...
- Tue Dec 12, 2017 5:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP stage not fetching data
- Replies: 4
- Views: 3528
There are LFM1, LFA1and LFM2 tables in SAP all contains data.LFM1, LFA1 data are successully extracted from DataStage using ABAP stage but data is not being extracted from LFM2 through ABAP stage.This job contains ABAP stage ---Tranformer -Sequential file stage(No tranformation logic).This job finis...
- Mon Dec 11, 2017 8:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP stage not fetching data
- Replies: 4
- Views: 3528
- Thu Dec 07, 2017 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP stage not fetching data
- Replies: 4
- Views: 3528
ABAP stage not fetching data
Hi ,
in one of the ABAP stage , we want to extract data from one SAP Server.Job completed without fetching any records .
from Remaining abap stages data fectching.
Please let me know why data not fectvhing from one abap stage.
in one of the ABAP stage , we want to extract data from one SAP Server.Job completed without fetching any records .
from Remaining abap stages data fectching.
Please let me know why data not fectvhing from one abap stage.
- Thu Nov 30, 2017 4:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Comparison logic not working
- Replies: 3
- Views: 14532
Comparison logic not working
Hi Team , In our project , we are doing reconcillation on 2 sources. in both source , one source file is in .txt format and other source is in form of .csv . In reconcillation job before comparing 2 sources , in transformer stage , we are trimming all fields in both source files. for reconcillation ...
- Fri Apr 07, 2017 6:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading CSV file, check no of columns in each row
- Replies: 1
- Views: 2280
Reading CSV file, check no of columns in each row
Hi, My requirement is Reading CSV file,next check the number of columns in each record in CSV file = 3 or not? Input : 1 2 3 A b c d e 6 1 2 3 4 E T L 1 2 3 Required files as column count in record= 3 Output : 1 2 3 E T L 1 2 3 Create error file ,column count in records <> 3 into error file Error fi...
- Wed Apr 05, 2017 11:44 pm
- Forum: General
- Topic: Sending multiple files to Multiple folders (same FTP Server)
- Replies: 2
- Views: 2468
- Wed Apr 05, 2017 9:49 am
- Forum: General
- Topic: Sending multiple files to Multiple folders (same FTP Server)
- Replies: 2
- Views: 2468
Sending multiple files to Multiple folders (same FTP Server)
Hi , My requirement is Sending multiple files, based on file name to different folders (same FTP Server). File Name Destination Path A.txt /Output/AAStndldGen B.txt /Output/BBStndldGen C.txt /Output/CC send output files to target FTP server(Same FTP server for all uploading file) based on file name ...
- Mon May 25, 2015 7:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
- Replies: 7
- Views: 8399
- Fri May 22, 2015 7:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
- Replies: 7
- Views: 8399
- Fri May 22, 2015 4:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
- Replies: 7
- Views: 8399
[IBM][CLI Driver] CLI0143E Invalid precision value
Hi All, Job designing like this : DB2 stage - > XFM stage -> DB2 stage source query used in db2 stage: 'select 'S' as no ,'Sucess' as def_va ,REQUEST_ID,REQUEST_SEQ_NO from MDCRDBA.textract_recurr_tbl WHERE REQUEST_ID=#REQUEST_ID# AND REQUEST_SEQ_NO=#REQUEST_SEQ_NO# and REQUEST_STATUS_CD <> 'F' ; ' ...
- Fri May 22, 2015 4:33 am
- Forum: General
- Topic: version migration from 8.1 to 11.3
- Replies: 3
- Views: 3119
version migration from 8.1 to 11.3
Hi All, My client requirement is migration of jobs from 8.1 version to 11.3. Taking all jobs export from 8.1 and directly importing into 11.3 version and compiling all jobs, it will work ? or need to migrate from 8.1 to 9.x , then again 9.x to 11.3? please suggest best approach . Thanks & Regard...