DSXchange

If you want to have two different files, have another column as indicator from source with the above query modified. I dont have database access now to test the query, but it should look something like below. Select col1, col2, (select Decode(sign(count(*)-1),0,'N','Y') f...

Check whether your project folder is full. What is your job design. It seems the job log is hitting the max limit. Are you loggin any message withing the job. Post the full warning/error message that appear in the log, Do you find any other message below/ above this message? Do a reset, and find the...

Abort may be due to excessive warning message (50 max). But why the job with warning has been promoted to Production without been handling in Development or Testing environment?

COL_ID[1,10] will just give you substirng of the first 10 charecters. If you want the based on the length, it has been explined in the previuos post.
If you need the first char in the first link and rest in the second file, then use COL_ID[11,len(COL_ID)] for the second file.

sequential records not in sequence eventhough its processing all records.

It do process in sequence, unless its been sorted withing datastge.
Can you explain your job design in detail. May I know what is the reason to split and write the records.

Kris - I guess it is about Server Edition.

Sort the records based on the required column. You need to compare the previous record with current record . This can be done easily via stage variable. User three stage variable in transformer. vOldRec = '' vIsEqual = '' vCurrRec = '' Initialise all the variable to '' In transormer derivation, vOld...

Make the output for the same format. And do a diff between the input and output file.
So that you can get those odd 106 records. Then you can find reason why it is not been capture even in the rejects.

http://dsxchange.com/viewtopic.php?t=102427&sid=c2ee33a6715fd1c786f08fb6e1c09bc8

Perhaps dsdesigner need to work with his sid stuff

Try to play with following command to know whether the file is empty in dos.

chulett wrote:I've had the problem here with HP-UX. Definitely saw it under 7.0.1, not sure I've checked again with 7.5.1A.

I have heard the same for the version 7.0. But fortunately, I haven't faced any such issue with the version so far.

If you go through the orchestrate manual, you may find as most of these stages inturns uses the unix Head, tail... comands.
For special cases like, capturing header or trailer records, you can use these staegs (if yor are not proficient in writing scripts in unix.)

Yet no answer for the first question asked.

We received the reply as soon as we send the first mail, but not after that.

As explained in the other post, Clear the partition on the output table for the Preserve Partion option.

I have tried the copy stage theory, setting the preserve to clear, this does not suppress the warning What is your job design, post your full warning message, addressing the the name of the stage. Most of the warning can be get ridden. Unless you have a sequential oprator connected to a preceeding ...