Hello,
How are encoded your input data ?
Search found 50 matches
- Thu Mar 05, 2020 9:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: French Characters Random Conversion issue
- Replies: 2
- Views: 6574
- Wed Oct 23, 2019 8:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP enable,Wanted to know if there is a way to avoid warning
- Replies: 3
- Views: 7291
- Tue Mar 27, 2018 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Records are not populating while Using RCP in job
- Replies: 2
- Views: 2767
- Thu Feb 15, 2018 11:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple records based on value in column
- Replies: 8
- Views: 6148
- Wed Jan 10, 2018 11:14 am
- Forum: General
- Topic: Select rows from table and use results as parameter to job
- Replies: 6
- Views: 5205
As for the original topic of this post - selecting rows from a table and using the results as parameters to a job, I think you have confirmed my lack of results from searching. That is, in a job sequence, it is not possible to read values from a database table, put those values into a list / array ...
- Thu Nov 16, 2017 2:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector Multiple update Queries
- Replies: 11
- Views: 11107
- Thu Nov 16, 2017 2:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector Multiple update Queries
- Replies: 11
- Views: 11107
- Thu Nov 16, 2017 11:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector Multiple update Queries
- Replies: 11
- Views: 11107
- Thu Oct 05, 2017 4:05 am
- Forum: General
- Topic: Export using dscmdexport failing to attach to project
- Replies: 3
- Views: 3480
- Fri Sep 22, 2017 1:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Parallel schema file - indicate # of rows to skip
- Replies: 8
- Views: 7225
- Tue Sep 19, 2017 5:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Parallel schema file - indicate # of rows to skip
- Replies: 8
- Views: 7225
You could use the "Filter" option of the Sequential File stage to skip the first rows from a file, for example :
will skip the first 3 rows.
Code: Select all
sed -e '1,3d'
- Thu Aug 31, 2017 7:14 am
- Forum: General
- Topic: Ascential DataStage Multiple Security Issues
- Replies: 4
- Views: 3265
Re: Ascential DataStage Multiple Security Issues
The solution was right under the text you copy / paste from cnet.JoeClark wrote:I didn't find the right solution from the internet.
- Tue Aug 08, 2017 3:53 am
- Forum: General
- Topic: Automated Tool for ETL Testing/Validation
- Replies: 5
- Views: 5159
Maybe you could take a look at John's posts on that topic :
- Thu Nov 10, 2016 7:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File Validation with schema and column import
- Replies: 6
- Views: 4680
It is possible to set a string defining a null value in the Column Import stage or directly in the schema. The easiest way is to add it to the schema, you can add the 'null field' property that way: record {final_delim='end', quote=none, delim=';'} ( C1:string[max=24] { null_field = '' }; ) To add t...
- Wed Nov 09, 2016 11:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File Validation with schema and column import
- Replies: 6
- Views: 4680