DSXchange

I know there was a topic regarding this but it was just explaination which i agree. But we have a situation which we have to insert an empty string to null varchar columns in teradata. When i insert '' and then i select from table i see null, when i insert setNull() i get the same, and when i trim s...

Thanks, I figured that out by option -ljobs.

but this is a weak thing, you should be able to name what you want in your folder or category just like informatica.

I did, but where do you specify the category?

say in the project you have two categories and both categories have a job named jLOAD, how do tell dsjob to run which jLOAD?

I did, but where do you specify the category?

say in the project you have two categories and both categories have a job named jLOAD, how do tell dsjob to run which jLOAD?

I have been running the jobs from client. Now i have to call them from command line using dsjob. what is the exact syntax? dont laugh. where do you specify the project, where do you specify the category? for example the project is called DWSCM and under that are three categories for three department...

write your output to a file rather than oracle. look at the file, if you have "hello" in the file it means you are screwing something before loading, if you see "hello " then there is problem in loading. make sure the string size is correct. if the target field in the transformer...

write your output to a file rather than oracle. look at the file, if you have "hello" in the file it means you are screwing something before loading, if you see "hello " then there is problem in loading. make sure the string size is correct. if the target field in the transformer...

I had this problem. But you just convert the PIC 9(9) to PIC X(9) in copy book and reimport or just change it in the CFF gui. but just make sure once you do it, go to ouput and on the mapping click on << and then on >> once, otherwise you will read as a char but will try to write it to output as COM...

gateleys wrote:

landaghaar wrote:That sux.

The if-then-else might, but not if you used Ereplace function.

How would you use that? Ereplace can only replace one string, how can you make it work like DECODE function in oracle or CASE statement in programming?

That sux.

I had similar problem, unfortunately no one could help me here. I had to find the answer with try and error thingy. Do the following steps: 1. import the copy book 2. double click on the definition 3. select the "parallel" and delete the following properties: Record type= implicit characte...

Is there any way to use in a Transformer Expression to handle multiple replace statements?

Just like CASE statement in programming or even in databases:

CASE param:
When 'A' Then 1
When 'Y' Then 2
When 'X' Then 3
When 'M' Then 4
....

check your source file, perhaps it was created on windows and by default datastage reads unix files.

double click on the inputfile, click on format tab and select Record Delimiter String and then select DOS format. it should fix your problem.

it is because of the extra character in dos.

Yes, but same results. It does not change the mainframe type to standard reqular type.

Here is the export of the definition, see they are marked as binary, i dont want that, i want to copy the definition and make another one with standard types. BEGIN HEADER CharacterSet "ENGLISH" ExportingTool "Ascential DataStage Export" ToolVersion "4" ServerName "...