DSXchange

Hi, I have to load a flat file which has 4 key columns and around 50 data columns. I would like to load this into a table that has 4 key columns and one xml column. I would like to load all the 50 columns data in to this single xml column. For doing that when I see IBM documentation I see 2 pdfs one...

I had problem with aggregator stages which were giving almost all column values as zero except for few records. I was able to resolve the issue by changing partitioning but still i don't understand what caused the issue in first place. Job Design for section of Interest. Remove Duplicate Aggregator ...

Hi, We normally load, load ready files into db2 using db2 connector.Normally our files are around 10 million records. If the load process fails say after 5 million records.Then we have to manually delete it using dba help. Dba takes long time to delete since he has to break into smaller sqls so that...

Hi, I have a file which will have list of files that i need to read. All this files will be in same directory and but non similar names. How could i make this read these files using sequential file stage or any other stage. Say My main file is: Filelist.txt. It contains following data input1.txt hou...

So it seems you may have found this post if you know about skipping Domain authentication. Did you read their resolution and try to verify that your permissions "all the way down" are correct? I read the post you pointed to and all the posts that post i pointing to. I have 2 questions. Qu...

Doesn't work either.

Status code = 81005

PaulVL wrote:try the -lprojects first to see the proper spelling.

I tried it. I am getting following error.

Status code = 39202

Help is appreciated.

Hi, I am trying to view log through unix and tried following command: $ dsjob -logsum Development ins_loans_table ERROR: Failed to open project Status code = 81005 Then i tried $ dsjob -domain NONE -user ABC -password XXXX-server dsserver:9080 -logsum Development ins_loans_table ERROR: Failed to ope...

If svOrderDate is char[8]. '20100301' is a char. Then do i have to convert them to decimal or integer before comparing them svOrderDate < '20100301' And say svShipDate is char[8] and svCancelDate is Char[8]. And if i have to compare svShipDate and svCancelDate then do i have to convert them first in...

First question would have to be why are you converting a string to a date and then comparing it to a string? Does svOrderDate include a time portion? Or maybe including dashes between fields? In this am i not comparing Date with a date? StringToDate(svOrderDate,"%yyyy%mm%dd") < '2010-03-0...

Wierd behavior of StringToDate conversion depending on location in If statement. If IsNotNull(ORCL.ORDER_DATE) and svOrderDate<>'' and StringToDate(svOrderDate,"%yyyy%mm%dd") < '2010-03-01' Then 'ABC' Else 'DEF' In this case the job throws warning as follows: Copy_of_Transformer_77,0: Conv...

The datastage job i am developing deals mostly with date columns. The source columns are a char [8] fields. These fields stores dates in format 20100101 i.e. yyyymmdd The job should should be able to handle all kind of junk data. so when ever i am hitting null or invalid date in this field i make it...

I have tried using 025, 222 for all this it fails with the following error: DST_BenefitPlanLoad_MBR_PAY_DSGN_STEP_SUM_DIM_ins: Error when checking operator: "delim_string" property must have a string value; text: delim_string=222 When i use char(222) or @FM then the job runs fine but the d...

ray.wurlod wrote:something that was moved to another thread.

Would appreciate reply on my question.

Looks like my thread is being hijacked. :D

I am clear about the partitioning. My question was more towards the sort on each partition.

Will these stages maintain same sort order in output as input per partition.