DSXchange

What is the easiest way to create a pipe delimited file where the length of the columns should not exceed the declared size? Example: source column is char(50) and in the target file I am declaring char(40). In the above example DataStage is writing all 50 characters to the target as it is not a fix...

Is there a way to convert the input date into internal format without knowing the format it is in? Input Date can be in below formats: 14977 ----internal format 2009-01-01 2009/01/01 01/01/2009 Irrespective of the input format my output should be 14977 (in the internal format) Is this possible with ...

Hello All, I am trying to pass a number (Ex: 6000) as job parameter and use that parameter in the stage variable. But the job parameter is acting weired. Below are the complete details. I added a job parameter with name AmtDiff with value as 6001. My logic int he stage variable is StageVariable : sv...

As noted, comment out that whole section and then stop/restart DataStage. Chulett, Thanks for the very quick reply. If I comment that whole section out then will that affect anything that was listed in the code? I mean $DSHOME/java/jre/lib/PA_RISC2.0/hotspot/libjvm.sl. Sorry if this is a simple que...

BTW, we are HPUX 11.11 as well. Ascential recommended we comment out the LD_PRELOAD statement in the dsenv. We did it and voila, kornshell scripts work again. Thanks again for your responses and collaboration here. We are facing the same kind of problem Below is what I found on the dsenv script abo...

Hello All, It would be appreciated if I get some help in fixing the below data type error. DataStage Job 582 Phantom 12315 Program "DSU.rtnSproc": Line 60, Improper data type. Attempting to Cleanup after ABORT raised in stage ClmExp..TransformTrn DataStage Phantom Aborting with @ABORT.CODE...

I am not sure why and how but using the below function kind of solved the problem and loaded the records fine into the target database. Oconv(Arg1, 'MD3') Thanks again for all the inputs. How are you guessing that the error is something to do with these columns only? Is there any date column also wi...

Thanks very much for the quick input.

I am trying to populate 3 columns using some simple calculations like addition, multiplication using another column which is of type decimal.
All the three target columns are of type decimal.

Hello All, I need some help in tuning my datastage load job. I am using DRS stage as source and target to load the sql server tables. I am trying to load 3 million records from source to target which is taking close to 5 hrs and there are no transformations involved in this job. I want some ideas to...

Thanks Ken.

The pipe file is created before the job starts using the mkfifo command but not as before job routine.

As I said the first job design writes to it and the seconds read from it. Do you think it is pure luck that the first job runs first as there is no control which one starts first?

kumar_s wrote:I havnt checked Current and previous SCODE but only SCODE <> 09.

Can you please provide your values inputs on how to achieve the last two records scenario?

thanks

Thanks very much for the help. I will try the provided code and get back as I don't have access to datastage now. Does your code provide the expected results for the last two records scenario? I am asking this because even if the current and previous records are same as scode = 09 those records shou...

Hello All, I need some inputs in completing the task below. Source: MNO PNO SCODE CNT --------- --------- ----- ----- MM0051789 PR0021989 88 10 MM0051789 PR0021989 09 20 MM0051789 PR0021989 90 15 MM0051789 PR0021989 60 10 MM0053322 PR0022244 09 10 MM0053322 PR0022244 09 22 I have to compare MNO and ...

Try using the RowProcCompareWithPreviousValue() function available with DataStage. It allows you to compare your current value with the previous value. gateleys Thanks for the inputs. I was successfull in comparing the previous and current values and also successfull in checking the date ranges. Wh...

When i click on view data everything works fine. I go back an import a new column and click view and thats when i get an invalid column name. I don't understand why i'm getting this error, the column name is there for me to import it. does this make any sense? Try this: Open your source odbc stage ...