DSXchange

sachin1 wrote:do you want all the columns to be propageted.

I need all columns output

Hi, I have one flat file have 114 cols. I have to select the data based on the max(effective date), How to do this rek. shall i need to use aggregator , if I use aggregator stage I need to group by all 113 columns except max(date) column? or its enough to group by key columns? or any other simple wa...

Hi, I am loading the data into database. I have one column in target table. Its length is varchar(40), some times the Incomming data is more than 40 charactors. so those records are rejecting. I am using trim() to remove leading charactors. But the trim is not working, what is the reason? records ar...

DSguru2B wrote:Then maybe your target length is equal to your source length. Check the metadata and also your constraints again.

Hi,
Incomming postal code is 13 charators, but in target file I have 10 charactors. and I am not using any constrains to load the postal code.

and I select the reject row also .

DSguru2B wrote:How are you capturing the rejects? Is it via a constraint or any check within the transformer or you are letting the database reject it? ...

Hi,
I am using transformer, if the incomming data length is more then target file, that record should go into reject file. but it is loaing into target.

Hi,
when I am loading the data into table , the unmatched records are going into reject file. for the same copy of job, I am loading the data into flat file. But I did not find the reject records.

how to get the reject records when I use flat file.

Thanks in advance

ray.wurlod wrote:Performing arithmetic will strip the leading zeroes, because arithmetic in DataStage BASIC returns the shortest possible valid string representation of the result. Use Fmt() to reinstate the leading ...

Could you please explain me clearly, I need the formate as starts with '0000100000'.

Fair enough ! :) For those whose find the above routine is suitable, use it, if someone believe it needs improvement, please create and use. If I believe an SDK routine is suitable for my purposes, I use it; if I believe it needs improvement, I create and use ... Hi, I have one solution, Correct me...

Hi, I need to genarage sequence of numbers . for that I am using keygenrateNextValue. the type of the column is varchar(10), the formate of the key is starts from 0000100000. Please advise me how to start from that number with in that formate. And secondary thing is KeyGenarateNexValue is a string, ...

Hi
I have two flat files... I joined those two flat files using hash files. and two files have some constrains, I mention those constrains in transfarmer. when I try to run the job all records are rejecting.

Can any one advise me .

Thanks in advanse

Hi, Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly. the result is if sub sequencer is fail your main sequencer also will fail Hi , While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted...

Hi, Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly. the result is if sub sequencer is fail your main sequencer also will fail Hi , While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted...

Hi, Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly. the result is if sub sequencer is fail your main sequencer also will fail Hi , While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted...

Hi, Thanks for your reply, My question is, I need to genarate sequence of numbers. The formate of the number is 'PART1'. The columbn datatype is varchar. I can concadinate the "PART:KEY GENARATE NEXT VALUE" If I did as above , it is loaded as string. If I want query on this column I can't....

concatenate them as below in the transformer . "PART":KeyMgtGetNextValue('ID'). Hi, Thanks for your reply. I need some other information on this. If I want query on this key column, how can I do that? let say If I need rage of values between PART10 AND PART30, how to get those rage of val...