DSXchange

Hi All, I am having trouble putting double quotes around a field when writing to a sequential file when the field contains a comma. The file itself is a CSV. So if the field does not contain a comma within it, it shouldn't be enclosed within double quotes, but when the field does contain a comma, it...

So there is no way to load that into Oracle the way the record is currently. Got it.

Do you know why the record shows as ";887"?

Hello all, I am having trouble with extracting out a record in the Sybase ASE database with a date format of "0/0/0000". When the record is extracting or viewed inside the stage, it comes out as ";877" which is obviously not a valid date format. The job format I have is just taki...

UTF16 did not work. And the problem is before the Oracle client. It is when the data is extracted into IIS, the extra chars are added.

It is failing because on of the target columns is VARCHAR(20) and one record is 21 length (it is not 21 in the source). When the data is extracted out of Sybase, it add extra bytes to the data for special characters (it hold telephone data). So the job fails because it cannot insert a record that is...

Ok. So if my job is:
There is no way to apply Unicode unless I add a Modify stage? And that is with RCP?

I do not use schema files to specify the table definition. My job is a very generic job. It takes data from Sybase to Oracle - a one to one move. The Select statement is generated by a routine by gathering the column names from the Sybase system table. This is done so we can load many tables using o...

Hi all,

Is there a way to use Unicode with RCP?

Thanks in advance.

Thanks chulett. Your suggestion worked.

Ah ok. So you are saying by putting the below just in the trigger, no matter what, it is always true?
I will test out your suggestion.

Thanks.

Thanks. If you are saying the RUNWARN has to succeed in order for it to move forward, then something else must be at play. My current trigger for the 'success' link was: DSJS.RUNWARN or DSJS.RUNOK And for my 'failed' link was just the Expression Type 'Failed' option. So then my question still remain...

Thanks for the quick reply chulett. I am not a premium member, so I cannot see your entire answer. However, I am thinking you are confirming my beliefs that DSJS.RUNWARN can allow the sequence to continue even if the job is aborted when the job has warnings. I would think the safest route with have ...

Hi all, I have a sequence job that contains say 5 parallel jobs. In the fourth parallel job trigger, I have to output links. One link is for a "successful" run, and the other link is for a "failed" run. For the successful trigger, I have this conditional statement: "DSJS.RUN...

How could I convert those columns to Numeric if I do not know which ones I need to convert since I am using RCP?

Hi all, I have a job that uses a file to provision Oracle tables into Netezza tables. Below is the simple job set-up: Oracle Connector ---> Netezza Connector I am using RCP and selecting all data from the Oracle source table. In the Netezza connector, we are using the 'Replace' table function. One o...