Search found 34 matches
- Mon Jun 10, 2019 5:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar(max) SQL Server
- Replies: 5
- Views: 5482
- Thu May 23, 2019 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connecter - Do Not Truncate on Failure
- Replies: 3
- Views: 3293
I agree with your design, I copied the job and replaced OC with a CopyStage. I did all my field validations in this job. The next job will just take the file and load it to the actual table. There is still a chance of truncating the table if any issue with loading data to table, but I have covered 9...
- Wed May 22, 2019 5:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field length more than 8000
- Replies: 3
- Views: 3995
I would suggest you import the table metadata in DataStage and see how the column you are referring is defined. Based on that, if you see the length is not sufficient, you can define the column as LONGVARCHAR and don't give the length. In most of these cases, you can try different definitions and yo...
- Wed May 22, 2019 1:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connecter - Do Not Truncate on Failure
- Replies: 3
- Views: 3293
Oracle Connecter - Do Not Truncate on Failure
Hello, My requirement is to truncate and load an Oracle table every day with a new file. But the catch here is, do not truncate if there is any issue with the file. My design has a external file, XML Input, transformer and Oracle Connector. I have mentioned to truncate the table. But when the job fa...
- Thu May 02, 2019 10:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mismatch in data read in DB2 AS400 using SQL client and DS
- Replies: 2
- Views: 2837
- Wed May 01, 2019 4:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple Repetitions in XML
- Replies: 1
- Views: 2723
Multiple Repetitions in XML
Hello, I know there are many posts related to this topic, but all of them are with older versions. My question is more around any better way to do this in latest versions. Issue. I have a huge XML file from a 3rd party application which has more than 30 repetition elements. I need to load all these ...
- Mon Nov 03, 2014 1:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Summarize entries based on multiple fields
- Replies: 5
- Views: 5062
Try to implement this: > Aggregate using ACCT and DBR-CD. So, you will get max two rows for each account and all the corresponding amount summed > then combine both the rows into single - now if any accnt has both C and D, you will have both the columns in the same row > delete the duplicates - so t...
- Mon Aug 11, 2014 4:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert quote into double quote
- Replies: 6
- Views: 5178
you can try my solution explained in the post -
viewtopic.php?t=152903
viewtopic.php?t=152903
- Mon Aug 11, 2014 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace String without Using EReplace Function
- Replies: 1
- Views: 3744
- Mon Aug 11, 2014 1:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Message getting dropped while extracting using MQ Connector
- Replies: 4
- Views: 3860
Can you please explain little more about your design.. You mentioned you are running the job in Keep mode and deleting the messages after you job read the messages. Are all the processes putting the messages in MQ are stopped when you are running your DataStage? If not, you might see more messages t...
- Mon Aug 11, 2014 12:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector Update statement
- Replies: 6
- Views: 11798
This statement doesn't give any error, it is added by the datastage to give you the number of rows it updated. If you see the log, you will have a statement - Number of rows updated on the current node: x. the number of rows are coming from this variable. The original poster wanted the clarification...
- Tue Aug 05, 2014 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Logic?
- Replies: 3
- Views: 3160
- Wed Jul 30, 2014 7:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join on subset of data
- Replies: 2
- Views: 2742
If I understand your requirement, you want to use some function similar to LIKE in Oracle. If substring of your oracle key is present in sequential file key, you want to output those records. In that case (you want only the matched rows), why don't you interchange your source and reference. have sou...
- Wed Jul 30, 2014 7:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to achieve the Scenario???
- Replies: 7
- Views: 4811
refer to the below post for Ray's solution using Mod function..
viewtopic.php?t=153014
viewtopic.php?t=153014
- Wed Jul 23, 2014 12:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scenario: Identify duplicated in a column
- Replies: 6
- Views: 5086