DSXchange

I appreciate your help. Thank you!!!

Hi -

Change the permission of the file that you are trying to copy. Sometimes this becomes an issue if you are running the job as a differnt user.

AK77

Verma - I have been reading quite a number of posts of the same issue. I think the meta data is your problem. You are getting the unknown column name error which is causing other problems I guess. There is a whole lots of posting on mutex error. Please do search and you will get the solution. Search...

Hi everybody -

I have a simple doubt. I recently learned that its not required to specify the format when u use ICONV alone to get the internal number for comparison
Is this always true?

Thanks
AK77

Verma - you need Premier membership to view the reply in full.

Ray - U always amaze me with your replies. You mean that it is possible to run the job even after fatal errors. Can you please explain how it can be done?

thanks
AK77

Yes thanks

I used the stagevariable to store the previous value and incremented the SeqNum with the logic given by you
And it worked fine

Thanks again
AK

Yeah I was thinking abt this while in lunch
And figured out that I asked a stupid question

Anyways this should work I guess and thanks for answering patiently

I take this moment to thank everybody

Whenever I had an issue, I always got a solution from this forum

Thanks again,
AK

Thanks,

So If I check for @INROWNUM = 1 does this reset for every group?
I thought @INROWNUM just gives the number of the row that is coming to the transformer

How does the seqnum reset for each of the group?

AK

Thanks, You mean to say take the sorted input and just use one transformer where you check if the Prev_In_Date = Cur_In_Date. If I just assign the field In_Date to a Stage Variable, does this Stage Variable hold the prev value Am sorry I am not sure how to save the previous value Thanks again AK

Yeah I understand that, but how do we do this I was looking at the routine RowProcCompareWithPreviousValue But how do i use it to check multiple fields Can I just modify this routine to take multiple argument? I know someone has already done this It would be great if someone gives me more info Thanks

Hi Everybody, I need to assign Sequence Number for transactions done on a paritcular day. My Input File ID Prcs_Dt Field1 Field 2 Feild3 In_Date Amt 2001 20060601 ABC 123 ABC156 20060501 200.00 2002 20060601 ABC 123 ABC156 20060501 1000.00 2003 20060601 ABC 123 ABC156 20060501 5000.00 2004 20060601 ...

No, I append the files in before job subroutine and pass through a transformer to update to an oracle table using OCI8 stage

Hope it is clear now Kumar

Kishan

Am sorry, this is a server job question I posted here by mimstake OK, OCI stage to select data from Oracle Using a parititioner and doing lookup against a hashed file writing it to Sequential files then Append the files as before job routine Update the columns in a table OCI stage One job for Yes an...

Thanks for the insight, I understand that Fixed_width is suppose to be faster I had another issue and this is why I am changing this file to Delimited ones I had this job running with delimited file and the data was all good I made some change to this design and wrote to one more file which takes ca...

Admin -

I posted this message by mistake in this forum
Can you please move to the server

Kishan