DSXchange

I am trying to use the Nested_Condition in a sequencer to route processing. When I use the following logic, I can't seem to get a valid indicator of 1 or 0 to return; Field(GetXrefHistCnt.uvXREF_5PK_FND_CNT,',',1) where GetXrefHistCnt.uvXREF_5PK_FND_CNT = 1 when I use Field(GetXrefHistCnt.uvXREF_5PK...

I received the following message when I switched the reference DB2 Connector from Normal to Sparse main_program: Data set, file set, or file "TCRSTAT_OUT_ref:TCRSTAT_TEST_ref_lnk.v": Non-pipe (or non-virtual data set) with .v in its name Data set, file set, or file "TCRSTAT_OUT_ref:TC...

I guess I need to clarify information in more detail, my apologies.

Source Records = 0

Target Table Missing

Datastage response: Warning


Source Records = 10

Target Table Missing

Datastage Response: Fatal

We found the answer. When there are no input records and the target table is missing, Datastage throws a warning. As soon as we have records from the input, the Datastage Job aborts.

The table really doesn't exist and Datastage is throwing a warning. First time I see this. Other jobs that use this table in other Projects abort. I have setup project and never seen a Error Severity switch to set the different levels. This one is really weird.

We're running PX 8.5 on Unix and during a run, we received a warning message stating that a table was not found. I know from previous experiences with Datastage that it would abort when this happens. The difference I see is, we are using Aliases and there was no data to load. We are running on DB2. ...

We are switching over from SMP to MPP and I was wondering if there is a way to globally switch the Enable Partition from "No" to "Yes".

Thanks

True but if you have many subsequent changes to the initial package, you need to restore back to where you were when all was good. This could mean restore original and all subsequent deployments. We are using this deployment strategy between Dev and Test as well. Usually, the test phase uncovers man...

But if you have 1000 jobs and 1 changes. You have to deploy 1000 jobs. It is too bad the product doesn't't flag the change and deploy only the updated jobs. This make more sense. Last week. We deployed a whole system only to find out there were some minor issues . Instead of a 1 minute deployment, i...

I am trying to implement a standard deployment strategy within our organization. Prior to this, we were using the Import and Export facility to transfer jobs between environments. Someone mention the Server Manager and packages and some of the benefits it has. Initially I was all keen on using it un...

I had to open a PMR for this problem. Can't seem to resolve. New version has a new environment variable called APT_TRANSFORM_COMPILE_NULL_HANDLING set to 1.

I set them all and still not working. I'll keep you posted

When using 8.1 I get the following message APT_CombinedOperatorController(1),0: Field 'SEGMENT20' from input dataset '0' is NULL. Record dropped. When using 8.5 with the exact same data, this message does not appear and the records are not dropped. I am trying to get 8.5 up and running but there has...

We have an input staging table that contains a column with a Varchar2(4000). We have had an increase in rows from 10000 to ~60,000. We are running under 1 node. Question: When Datastage reads the input, I assume it reads the column as 4000 even though it's variable. Am I correct? I increased to 2 no...

I am using a Stage Variable to setup the field as follows

IF IsNull(DSLink1208.SALARY_STEP_NUMBER) or DSLink1208.SALARY_STEP_NUMBER = '' THEN 'UM' ELSE DecimalToString(DSLink1208.SALARY_STEP_NUMBER,"fix_zero,suppress_zero")

I am getting 'UM' back when the source is 000.

My requirement is to convert a decimal to a string as follows;

001 = 1
002 = 2

but I need the following result for this one

000 = 0

I used the suppress_zero but end up with a NULL field. How do I go about keeping the 0

Thanks