DSXchange

arunkumarmm

Please post your code and your date format

arunkumarmm

I dont have a clear understanding on your approach but If i'm doing this I will try something like this: Sort rows using company code and product code. Assign the initial values for all stage variables as empty ( '' ) svOldComp = svNewComp svNewComp = Link1.CompCd Column svOldPrd = svNewPrd svNewPrd...

arunkumarmm

chulett wrote:Or use a BASIC Transformer? Does that not also work? Never had a chance to actually try that out...

I was trying to do this. Job doesnt gives any warning but doesnt assigns any value to the user status. I'm not sure If I'm missing anything.

arunkumarmm

I have a problem comparing 2 dates. could anyone pls tell me how to compare 2 dates in server job. How you want to compare the dates? If both the dates are in same format, you can simply compare like Date1 = Date2 etc., If they are in different format, use Iconv/Oconv to bring them in the same form...

arunkumarmm

Do you have any stage variable or column derivation that has complex IF..THEN..ELSE? If so can you post them all? In all of the transformers?

arunkumarmm

How you tried this? Can you post your approach?

Also, did you sort your rows before that? And did you include both company code and product code to validate?

arunkumarmm

Guys, I have an issue with the data that is loaded in to the sequential file. 1) 10161|000471276|Baja||||||||||||TX||4|0 2) 10175|000471276|Baja||||||||||||TX||4|0 3) 10161|000474056 |Baja||||||||||||TX||4|0 4) 10175|000474056 |Baja||||||||||||TX||4|0. I am getting that extra spaces or line for the...

arunkumarmm

kris007 wrote:Are you connecting to the database on a remote server? If so, you need to invoke the DB2 instance using the environment available.

I'm facing this issue as well, do we need have an entry in datastage server to connect to the DB2 database. [ Something similar to a TNS entry for Oracle?]

arunkumarmm

stilllearning wrote:First, is there a way to select and execute multiple HASH File Server jobs?

What do you mean by "multiple HASH File Server Jobs" ??? Do you mean selecting records from multiple hashed files from a single source stage?

arunkumarmm

Post the full unedited error you receive in your production environment. I am getting the below warning message: Abnormal termination of stage JobName.U2.CodaDateFile.IDENT1 detected Are you using any stage variable or constrain or expression in your transformer which has a IF..THEN..ELSE? If so ca...

arunkumarmm

ravitell1 wrote:when i try to use this Field(SRC_JOINING_DT,' ',2) it is giving me NULL.
It is not returning any value..

Or you can try this

Code: Select all

Field(Field(SRC_JOINING_DT,')',1),'(',2)

arunkumarmm

This doesn't works . The output is coming as 0,0,0,0, This should work. May be try defining the initial value of your stage variable to '' {Empty} If you are mapping the column properly, how come this doesnt work? No complex thing involved in this. You are just appending your column to the stage va...

arunkumarmm

anbu wrote:Or finish your processing in one job without sequence number if it is ok for your requirement. In second job create seqeunce number using transformer running in sequential way

I need to map this sequence number to the records which is errored out.

arunkumarmm

Ask yourself whether uniqueness is sufficient. If it is, gaps in the numbers are completely irrelevant. ... No Ray. I want the Input records sequence number. The requirement is, we have an error processing and which ever record errors, I need to cature the Input record sequence number and store it ...

arunkumarmm

anbu wrote:Run the parallel transformer in sequential way and use @INROWNUM

This is the current scenario Anbu. But the jobs run for a longer time. Say the job with sequential mode runs nearly an hour and making it parallel, it runs less than 10 minutes.

DSXchange

Search found 245 matches

Re: comparing 2 dates

Re: Trim

Re: Adding Columns to Dynamic RDBMS Stage (Server Job)