Search found 103 matches
- Mon Oct 26, 2009 12:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job hanging in Running State
- Replies: 2
- Views: 1888
Job hanging in Running State
Hello Everyone, We have a DataStage PX job that is running correctly in dev environment but in test Environment the job is not getting finished and remains hanging in 'Running' State. This same jobs runs fine if we set the parameter $APT_DISABLE_COMBINATION to 'True' for the job. Can anyoone help me...
- Sat Oct 24, 2009 1:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: string to decimal conversion
- Replies: 21
- Views: 11181
- Sat Oct 24, 2009 1:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Why it is in Sequntial stage? When u read data Fixed format
- Replies: 3
- Views: 2115
- Sat Oct 24, 2009 1:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What port DataStage uses to connect to the databases
- Replies: 8
- Views: 5120
As noted, that's all in the hands on the database and attending DBA. Please correct me if there is some problem in my understanding of the concepts. As per my understanding the Database details that we define in either tnsnames.ora file or in the .odbc.ini files contains only the port details of th...
- Thu Oct 22, 2009 2:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What port DataStage uses to connect to the databases
- Replies: 8
- Views: 5120
This thread should contain what you are looking for. ... Hi Arndw, Thanks for replying but I have gone through this thread before posting my question. The thread is specifically related to the Client connections to DataStage Engine but I didn't found any mention of the ports for Inbound/Outbound Da...
- Thu Oct 22, 2009 2:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What port DataStage uses to connect to the databases
- Replies: 8
- Views: 5120
What port DataStage uses to connect to the databases
Hi,
We just want to know what are the ports which Datastage uses to connect to other Databases on different servers.
Is it going to be port 31538 on which DataStage listens or Are there any other ports which are required for Inbound/Outbound interfaces of DataStage?
Thanks,
dsusr
We just want to know what are the ports which Datastage uses to connect to other Databases on different servers.
Is it going to be port 31538 on which DataStage listens or Are there any other ports which are required for Inbound/Outbound interfaces of DataStage?
Thanks,
dsusr
- Wed Jul 01, 2009 6:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise Stage: Converting Blanks to Null
- Replies: 3
- Views: 2671
Check $APT_STRING_PADCHAR as well. ... Hi Ray, Thanks for the reply but not sure how this variable is going to have an impact on this issue since we are only dealing with Varchar fields. Anyway the value is set to Null for APT_STRING_PADCHAR i.e. 0x0 Our problem is that we have a Varchar2(30) field...
- Tue Jun 30, 2009 3:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise Stage: Converting Blanks to Null
- Replies: 3
- Views: 2671
Oracle Enterprise Stage: Converting Blanks to Null
Hi All, We are facing an issue while using Load-Append in Oracle Enterprise Stage where all the Blanks are getting converted to Null. We tried setting the environment variable $APT_ORACLE_PRESERVE_BLANKS to true at job level but still the control file for SQL Loader have the condition: 'NULL if star...
- Mon Apr 20, 2009 6:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Limiting rows in parallel job
- Replies: 5
- Views: 2831
Re: Limiting rows in parllel job
Compile the Job in Trace Mode i.e. go to the Job Properties -- Execution Tab and enable the box Compile in Trace mode. Then you can limit the number of records per link for a partition.
Regards,
dsusr
Regards,
dsusr
- Wed Apr 15, 2009 3:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformer compilation error
- Replies: 12
- Views: 5431
- Tue Sep 16, 2008 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to auto-generate metadata?
- Replies: 8
- Views: 4347
Combining schema files and Runtime Column Propogation (RCP) could solve your issue. You have to use some good shell scripting to resolve this issue.... First you have to read the schema from Oracle and have to generate the Schema files which were then used in the generic DataStage job with RCP enab...
- Tue Sep 16, 2008 9:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing zeros for decimal values
- Replies: 7
- Views: 4474
If the data type is Decimal you can not remove the non-significant zeroes, because they don't actually exist. They are an artifact of how DataStage displays decimal numbers to prove that precision an ... Ray, Since the person has the target column as String so I suppose he can easily remove the dat...
- Tue Sep 16, 2008 8:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Concatenation of multiple values
- Replies: 12
- Views: 4760
Yes. I need your help in stage variable logic. Plz let me know. First sort the input data to transformer on the key MT_ID, MT_REPLACEDBYID...... In the transformer define the following stage variables STGCount ----> If InputCol.MT_ID <> STGPrevious Then '1' Else STGCount + 1 STGConcat ----> If STGC...
- Mon Sep 15, 2008 5:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: parameter for abort after n rows
- Replies: 2
- Views: 5565
Re: parameter for abort after n rows
Use the transformer options Abort after rows by using the Following Logic. Use a stage variable to count the number of rejected records. Create a link in the transformer with the Constraint that the Rejected Stage Variable Count > Job Parameter for the Abort. For the same link use the option Abort o...
- Mon Sep 15, 2008 4:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Concatenation of multiple values
- Replies: 12
- Views: 4760
You have o write the logic within the transformer to read the previous values. Do a lookup and you will get the following output from Lookup: MT_MODELNUMBER, MT_ID , MT_REPLACEDBYID A 101 1 A 101 2 A 101 3 Now you have to define the Logic using Stage variables in the transformer to merge these 3 rec...