DSXchange

Away from the topic at hand, we should have an FAQ entry that contains info on all these patches, along with error messages, so that search could turn it up. Just a thought.

Care to share the error message with us ???

Interesting info. Have to lock this one away in my favorites chest.

You will have to incorporate that pl/sql script into a shell script, kinda like a "here" script. Search the forum or on the net for examples of an "here".
See this example where Ray describes a "here" script for ftp.

Sure. You can wrap your pl/sql in a script and execute that script. This way you can capture your return as well.
I am not sure if multiple commands can be run. I doubt it.

I am afraid not. But you can create a procedure out of your pl/sql and call the stored proc. from within datastage.

Have you looked at IsValid() function?

Instead of including the entire path of dsapi.h, try including just dsapi.h

Durga wrote:client want us to remove everything after 100 including 100 and (

Ok, now that sounds like a rule to me.
How about this

Are you able to select the date from sql developer? What is the length of your date field, as defined in your table?

You need to tell us what rule to apply. According to what I see, from your examples, you want to get everything before the opening paranthesis "(". But then I see a record that has no paranthesis. You need to provide us with the proper rule, and we will guide you towards the code.

Your dsenv file should have the path of shared library set to $APT_ORCHHOME/lib.
Then you need to run the orchadmin command by running the following

A well documented source to target mapping does contain all this info. Maybe not to the extent of trimming the fields where required but the key transformations. I guess my answer was incomplete. The lineage tends to occur in different places. Most of it in the mapping doc, some in the job's documen...

It really depends upon what you are using the staging tables for. It also depends upon where the staging layer comes in. Right in the begining of the cycle before transformations or after transformations and right before loading the target. If your source has duplicates and you need to retain them, ...

Its here.