DSXchange

Hi my friend.
This command exists at the uvodbc.config and the DSN in the Universe stage is exactly like you mentioned.

Remembering that this error occurrs also with ODBC stages.
When it is an Oracle stage, the data returns ok.

Thanks guys!

Chulett, That's exactly what I have done. Actually it is a very simple job where there is a universe stage as the source and its result goes to a sequential file. The query is that one I mentioned above. I've already changed the uvodbc.config letting that one wich was created during the instalation ...

Have you considered using a Server job with the UV stage? ... Hi my friend. Let me correct something. Actually I am punctually working in a project wich they use server jobs. I forgot to mention this important point. The thing is: We have tested and both ODBC stage and universe stage return this er...

Hi everybody. I am trying to execute a Query at theUniverse Database but the following message returns: ReportJobCategory..DS_JOBS ( OpenPath failed for - /opt/IBM/InformationServer/Server/branded_odbc ): ReportJobCategory..DS_JOBS.lnk_DS_JOBS: DSD.BCIOpenR call to function OCONV failed . When the q...

Hi friends. I used the transformer to read the output from the Procedure and then, I directed this output to two peeks. One of them is to identify the problem. If a row passes by that link, the job aborts. I informed this action at the option: 'Abort After Rows' - I informed one row. So, when the jo...

You mean read the Output variable in the Transformer Constraint and check the Otherwise/Log Option if the result is different from the one that I want?

Or you have another idea?

Craig, thanks for your answer.

And where should I place/call this function?

Hi everybody. I am calling an SQL Server Stored Procedure through a job DataStage and, at the end of its execution, the job always finishes ok, independent on the Stored Procedure result. I can see its Output variable by the Peek - at the log - but I can take any action about it. I would like to pro...

Hi guys. For my surprise, in another Transformer, I created a VarChar field and in its derivation I wrote the same content and that special caracter didnt appear any more. I really couldn't understand. I just created the Field in another transformer, with the same derivation. Is it a Bug? I can't ex...

Hi Ray! I took out this environment variable to test, and the problem still happens. I also created the stage variable as Char(22) - the exact lenght of its content and it didnt work again. - I started it with ascii char(11). In another job wich this problem used to happen, I changed the field defin...

As noted, you really need to identify the character in question, its specific value. Only then will you be able to deal with it properly. ... I identified that the characters are: Null + Vertical Tab (ascii 11) But the convert function didn't work. The APT_STRING_PADCHAR could cause this? Configure...

First of all, thank you for the answer. What do you mean by: see if the ascii code is 0x00 ? What '0x00' means? Here we are using the APT_STRING_PADCHAR environment variable set like 0x20, but actually I don't know exactly what it means. Thankss! Here we are using the APT_STRING_PADCHAR environment...

First of all, thank you for the answer.

What do you mean by: see if the ascii code is 0x00 ? What '0x00' means?

Here we are using the APT_STRING_PADCHAR environment variable set like 0x20, but actually I don't know exactly what it means.

Thankss!

Hello friends. I have a problem. I am generating a Sequential File through DataStage and there is a column that always shows a strange character at its beginning like that 'char(10)', in other words, that little rectangle which means the 'Line Feed'. It causes the file truncation. We have already tr...

Guys,
Thank you very much for your explanations.


Best regards,