DSXchange

Hi Sylvan ,
May I know what you mean 'priority thing'?
Do you mean if a field A and B need to be sorted,
A B
1 1
1 2
1 5
2 7
2 8
2 8
2 9
Is this the order you are expeting? If so it is by default done by the DS.
If you are expecting anything else, pls specify.

chulett wrote:Just. Lock. It.

Is there a dang FAQ 'discussion' anywhere in there?

Not sure, why Craig's temper is getting worse in this regard, do something before it become worst.

Have you tried using the Peak stage to find out where exactly the information is getting lost?
Configure all the stages of the transformer,
1.input column directly
2. Stage variable
3. Output column before transformation
4. Output column after transformation.

If it is a lookup file set, you may find it indexed on the key marked.
You can easily find this by passing the main stream with unsorted data. If you get a match for all the input it doesnt read for where it left.
And you can post us your findings.

Have you tried the direct load of data to that table with a value in that char field.
Check if any trigger set to that table.
What the defenition of the field in database?

I am not sure how this ...[1,len(SF1)]:.. helped. This will just retreive you the full string other than the emptyspaces in varchar. If it is the case of char, it will give you the full string including the the emptyspaces, if it is about to be mapped to char field again. Try to use Trim funciton to...

In the loop

You can get us the root cause for that "SM 50 error", so that we can analysis in DS aspect.

By default the value of "APT_DECIMAL_INTERM_ROUND_MODE" would be "Round towards nearest representable value". You can experiment whether, change in this prarameter causes any difference in your issue.

Have you tried increasing the Row buffer as it is asking for?
May I know what is the use of Transformer next to Folder stage?
Try using IPC stage before XMLINPUT stage, with necessay settings.

jojipjohn wrote:Can I unpack the packed decimals and fixed binary decimals in the source file. If yes how is this done.

Is it a reply to any other post?
If not click on the "Post a new topic" with all informaitons like, the edition, platform, stages used...

What do you mean by " when I go to the job, and view data in the sequence " If you have passing the value from the sequence to the job, though the value is defined in project level, the sequence will get the preference. If you claim $PROJDEF in Jobsequence, it will fetch the value at the time of exe...

Another work of full Wurlod for Server transformer 1. Any before-stage subroutine is executed. If ErrorCode is non-zero, the job aborts. 2. A row is obtained from the stream input link. 3. For each reference input link, in the specified execution order: (a) the reference key expression is ev...

Do you mean the backup of version control project, if then it should be nothing more than normal export.
Still you have the document given in the client pdf.

Have look at the product classifcations here.
http://ibm.ascential.com/products/datastage.html