DSXchange

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...

Where are you viewing the output. If the target is table check the precision and scale for the column in target table.

Change the length of Record Length =Fixed to Record Length=12.

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...

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...

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

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...

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...

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

Hi Aggie,

Can you please tell me what need to be added in the LIB and INCLUDE variables of Windows because I have added the C++ library path i.e. "C:\Program Files\Microsoft Visual Studio\VC\lib" in both these variables but still the same issue is coming at my end.

Thanks in Advance
dsusr

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...

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...

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...

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...

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...