DSXchange

Thanks for your reply.
I have narrowed down the problem. It occured on the statement
When run by hand, the status is 0.
When run by scheduler, the status is -1.
The parameters are the same!
Any hints?

I have a routine in which it uses sql statement to get the maximum number of a column in a table (i.e. SQLExecDirect) When the job was run by hand, the routine was executed correctly. The weird thing is when I use director to schedule the job, the routine didn't return the correct number. Any input ...

I don't know how to deal with the binary(8) from the sql server. It isn't even displayed in a readable format. I think it is a standard sql server data type. The Oracle part is easy. Just need to know what kind of field you need to store it in - a DATE or a TIMESTAMP of some kind? However, the binar...

I have a table in sql server in which there is a column called TMStamp. It is defined as binary(8), and it is supposed to store the time a row is modified. Now in the transformer I want to convert it into a timestamp data type and store in my oracle table. I have no idea how to set this up in the tr...

It's the notification stage in a job sequence.

I have some chinese characters in the subject field. They can't be displayed properly in the resulting email.
I think maybe it is due to the fact that character encoding is not properly set up(where to set it?).
Any suggestion is welcomed! Thanks.

the input is a table in the sql server. A field is a bit (0 or 1). the output is a sequential file. In the transformer stage, I set the corresponding output field's SQL type also be BIT. The problem is when I view the output seqential file, I saw 1 in the sql server database table became -1 in the s...

Some times I need to create hash files with more than one keys. But in the transformer stage, I can't look up what I want.
Thanks

In the oracle table there is a new line character in a field of a row whose type is varchar(30). First I use oracle stage ---> sequential File, no problem at all. Later I need to read the sequential file back to another oracle table, b/c of the new line character, all the following records got misse...

Thanks for your reply.
I am just a little confused with the data element part.
Is there any scenario that you need to explicitly define the data element type
in order for something to work?

in the transformer stage? Can someone explain it in a little bit details?
Thanks.

Thank you for all the input!

I have a table called fund_info where I store fund related data like fund code, fund name, start_date, end_date etc. When a new record comes, I need to first check if it exists in the table by a primary key. If not, I know it is a new record and insert it into the table. Otherwise, it's already in t...