DSXchange

Hi,
What's the syntax for running Oracle Stored procedure in After SQL of the Oracle Stage.

I tried exec package_name.procedure('parameter');

and

begin
package_name.procedure('parameter');
end;

Didn't work.

Any help would be much appreciated.

Best regards
Marcin

Is the same two key marked in Sequential file. Is that the matching between the two file is based on these composite keys? As mentioned, are those keys which doesnt match, are without any extra leading/trailing spaces or special characters. I found the problem. one of the keys was decimal but in fi...

Make sure there are 99 rows in the hashed file by performing a count query on it. Even though DataStage may have reported 99 rows written, any duplicate keys will have been overwritten. Make sure ... Yes, there are 99 rows unique rows. Could it be caused by fact, that I have two fields defined as k...

Hi, I have source flat file plus other hash file that I link to transformer. In source flat file there are about 10k rows and in hash file there is only 99 rows. They should match to 99 rows from the source file but when I run the job there is only 95 of them that match. I don't see any reason for t...

DSguru2B wrote:open the file in a notepad, what delimitter do you see? do you even see any delimiter?

No, it is not a delimited file.

As I said from the specification I know that
first 2 characters is id, next 10 name, etc...

Best regards

Hi, I have a text file where are variable length columns. for example first two characters is id next 10 characters is name next 20 characters is address etc How to import such data in to the table definitions? I see there only option of fixed width columns and delimited ones? None of them is correc...

chulett wrote:Have you... tried it? What happens when you do?

I am getting error message:
"Cannot attach to project... , Your client version 7.5.1.A is not compatible with server installed version 7.5"

And I am looking for workaround...

Hi,

Is there any way to connect from DS Client 7.5.1 to 7.5 server?
would be very thankful for info.

Best regards
Marcin

There must have been character at the begining of the date, which was invisible in the log. Solved by using substrings function.

Thanks to everybody for help.

You still need to print out the bad value in your routine; it obviously is getting a different one from what you expect. Another approach that you can take is to use the debugger in the designer to find out the invalid value. Or you can put an output link in your transform with the value of data_li...

What are the argument values? Status() returning 1 means that the first argument can not be converted based on the second argument. For example "2006-01-27" can not be converted if the second argument is "D" if your locale's standard representation of a data is MM/DD/YYYY. You w...

Put calls to DSLogInfo() in your function to debug what values are actually being passed to your routine at runtime. The status of 1 means that your date string is invalid. Instead of using DSLogInfo() I just returned concatenated parameters with Status. Parameters were ok. I will try with DSLogInf...

Hi, I have simple routine Function checkDate(dateString, dateFormat) x= IConv(dateString,dateFormat) Ans=Status() When I test it it works perfectly fine. However when I use it inside of a transformer it returns 1. It happens when I provide data_link_name.column_name as a input for this function. Any...

MaheshKumar Sugunaraj wrote:Could pls check the Meta data of the XML, I had the same problem, so I actually re-imported using the XML Metadata importer and it worked fine.

With Regards
M

Problem with import indeed. Needed to mark those fields as a text.
Thanks for help

chulett wrote: Can't you use one of the Transformation Settings on the Output tab to 'Replace empty values with NULLs'? Seem to recall something like that in the stage...

I've tried it before. It doesn't help...