Search found 1274 matches
- Mon Aug 19, 2013 11:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: z/OS DB2 - Surrogate Key Generation Through Transformer
- Replies: 7
- Views: 5588
You should contact your official support provider in order to verify whether or not the Surrogate Key Stage (and the transformer's SK logic) support a DB sequence on DB2 z/OS. A workaround would be to call the DB sequence in the connector by using the NEXT VALUE function--this will require coding yo...
- Mon Aug 12, 2013 1:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date - 1 day transformationm
- Replies: 2
- Views: 2229
That is not the proper way to modify a date. Your source will be converted to a simple integer, then the math performed, then the outer functions performed. While probably most dates might work, several would not--for example, 20100501 - 1 = 20100500, which would not be a valid date. Take a browse t...
- Thu Aug 08, 2013 3:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strange issue while converting varchar to integer
- Replies: 5
- Views: 4217
Is the target defined as Number(16) or Integer? You've stated both :| It's not the conversion that's the problem, it's the datatype the value is being placed into. Make sure your datatype out of the transformer can hold the value. As Andy stated, an Integer cannot hold a value that large. Either a B...
- Mon Aug 05, 2013 8:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get the design of a job from Job Executable
- Replies: 5
- Views: 3470
There is currently no automatic method to do this that I'm aware of. You can examine the job's osh script and recreate it's functionality in the GUI. However, for any transformers, buildops and custom operators you will need the original source as that won't be available in an executable-only job ex...
- Sat Aug 03, 2013 11:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert opd to Buildop Stage
- Replies: 7
- Views: 6629
- Thu Jul 25, 2013 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter Set Change - Compile Jobs
- Replies: 12
- Views: 17728
This has been mentioned in other threads in the forum but bears occasional repeating for those searching: ParameterSet default values are included in the job at COMPILE time. Therefore, hardcoding default values for parameters that will change value over time (such as userids and passwords!) is neve...
- Mon Jul 22, 2013 10:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No input sort key information found
- Replies: 3
- Views: 5166
- Fri Jul 12, 2013 7:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row generator and Column generator
- Replies: 4
- Views: 3657
Column Generator is probably already running in parallel. Row Generator runs in sequential mode by default. You should understand that by setting it to parallel, you will have more records generated (number of nodes executing * number of records requested). You may not want to do that, or you may wa...
- Wed Jul 10, 2013 10:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: state files in surrogate key generator
- Replies: 13
- Views: 16895
Use the block size of 1 if you require it, otherwise you should consider the default or even larger block sizes if you are assigning a lot of surrogate keys. Lower value block sizes introduce more overhead to the job due to needing to access the statefile more often. I've seen a block size of 1 brin...
- Wed Jul 10, 2013 5:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12033
The transformer will evaluate the entire logic of a complex condition, even if one of the conditions of an OR construct is already true. This can cause issues like this when null handling is combined with other conditions as in your logic. The sequential file records make it through probably because...
- Wed Jul 10, 2013 4:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12033
- Mon Jul 08, 2013 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mainframes DB2 on z/OS moved to DB2UDB on Windows-DS Impact
- Replies: 3
- Views: 2611
All of those stages should work with DB2 on Linux/Unix and Windows. You should contact your official support provider for verification and for the specific versions of DB2 supported by those stages in the version of Information Server you are working in. FYI...there is no need to send a private mess...
- Sun Jul 07, 2013 11:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mainframes DB2 on z/OS moved to DB2UDB on Windows-DS Impact
- Replies: 3
- Views: 2611
Which DB2 stages are your jobs using? In general, the DB2 Connector stage is compatible, DB2Z stage is not. If the DBAs perform the migration successfully, you shouldn't have any data issues but you should ALWAYS thoroughly test to identify any issues that may be particular to your environments. Reg...
- Thu Jul 04, 2013 10:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: doesn't required column in file output, when no data in colu
- Replies: 3
- Views: 2877
Yes, either through the filter option in the sequential file (calling awk or sed or cut commands) or by running an external command against your file after it's been written. Either way, if you leave the 4th column defined in your output you will need to supply some sort of data for it, even if it's...
- Thu Jul 04, 2013 7:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: doesn't required column in file output, when no data in colu
- Replies: 3
- Views: 2877
You have to make a choice: You will either need to remove the 4th output column from your output definition or populate the column with default data if you need to keep the column defined in the output. What drives the choice: What is required by the downstream process that receives your output file...