Search found 37 matches
- Fri Apr 05, 2019 1:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Db2 Connector Stage Write Partitioning Method
- Replies: 2
- Views: 3096
Thanks Ray for the Reply. As mentioned, the Table is Hash Partitioned by Different Column (Col: 1) and the Updates in this Job are done by different Columns (Column 12: Column 18 and). And we have Index on Column_12 and Column_18 still the updates are taking longer time (we are updating around 200+ ...
- Thu Apr 04, 2019 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Db2 Connector Stage Write Partitioning Method
- Replies: 2
- Views: 3096
Db2 Connector Stage Write Partitioning Method
Need Experts advise. We are updating a Db2 Table (Around 200 Columns) based on Where clause which are indexed. Input: Sequential File Output: Db2 Connector Stage Operation: update Input_File --> Transformer --> Db2 Connector Stage. Update Statement: Update Table_name set col_1 = ORCHESTRATE.Col_1, C...
- Fri Dec 22, 2017 10:07 am
- Forum: Site/Forum
- Topic: Spambot
- Replies: 28
- Views: 68907
- Thu Dec 21, 2017 1:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IsNull() from Excel data issue
- Replies: 2
- Views: 2452
Re: IsNull() from Excel data issue
Check with the system whoever is creating the excel if they are correctly populating the NULL Values (or Add Constraint <> '<NULL>' and see if the data is getting Filtered out by the constraint. I tried sample ds job to create unstructured data with 1 Column as NULLABLE Yes and set to SETNULL() and ...
- Tue Dec 19, 2017 10:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8409
- Tue Dec 19, 2017 9:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8409
- Mon Dec 18, 2017 1:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with left justified column with spaces in fixed length
- Replies: 3
- Views: 3032
Re: Issue with left justified column with spaces in fixed le
Please provide your Output File Format
Spaces between columns: This field is only active when you select the Fixed-width columns check box. Contains a number to represent the number of spaces used between columns.
Spaces between columns: This field is only active when you select the Fixed-width columns check box. Contains a number to represent the number of spaces used between columns.
- Fri Dec 08, 2017 8:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Custom Routine Issues
- Replies: 5
- Views: 4786
Re: Custom Routine Issues
Check below link and see if this is of any use for Custom Routine creation:
https://blogs.perficient.com/delivery/b ... datastage/
https://blogs.perficient.com/delivery/b ... datastage/
- Wed Dec 06, 2017 8:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion
- Replies: 3
- Views: 3566
- Tue Dec 05, 2017 12:14 pm
- Forum: General
- Topic: Batch ID in Datastage
- Replies: 19
- Views: 10023
- Tue Dec 05, 2017 8:25 am
- Forum: General
- Topic: Batch ID in Datastage
- Replies: 19
- Views: 10023
- Wed Nov 29, 2017 8:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema reconciliation detected a size mismatch for column
- Replies: 14
- Views: 16641
Any Idea why Datastage is treating as DECIMAL(31,0) when casing as DECIMAL(31,5) and defined as Decimal (31,5)? Also, Can you make sure that the order of the columns are correct and Just View Data for the 1 Row (Sample you mentioned) in both DS Versions and make sure that you are getting 0.45 in old...
- Mon Nov 27, 2017 12:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC - multi copybooks, recordId and link col err
- Replies: 9
- Views: 6270
- Mon Nov 27, 2017 9:46 am
- Forum: General
- Topic: using SQL in routine
- Replies: 7
- Views: 4463
- Mon Nov 27, 2017 9:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC - multi copybooks, recordId and link col err
- Replies: 9
- Views: 6270
Re: EBCDIC - multi copybooks, recordId and link col err
Ask your mainframe support person to do num off std and then download again so that numbers on left side will go off and make sure that 01 level record starts at 8 position. I have removed the line numbers and removed the comments from your Cobol Copybook and could able to successfully import 01 RDK...