DSXchange

This would be buried a couple of levels deep in the web IBM Information Server. Login, do Administration -> Domain management. Select and edit your domain and the "DataStage Credentials" tab will have that check box.

Yes, it can be done. FTP is one of those tricky commands, as it takes several lines of input. I've found that each UNIX implementation has a slightly different syntax or method of doing this. I would use google and your flavor to find examples.

In this the line number was correct (a rare occurrence). The $R63 is supposed to be assigned in the previous statement so I would think that it could be an uninitialized stagevar as well.

Using "ftp" would be the simplest method. You can use a copy stage to create 2 outputs in your job, one going to FTP and the other to a local output file. Or create the output file and then use an after-job call or a script to FTP that file to the remote machine.

dodda - the important part of the question is what datatype is getting the space, your code makes it look like a numeric field.

Where are you getting spaces? The code indicated that the output is a numeric column, not a string. Normally spaces in a string are considered NULL (with the default setting of $APT_ORACLE_PRESERVE_BLANKS). What stage are you using to load Oracle?

Line 804 is in the DSD.StageRun BASIC program, not in the generated code of your job. The whole job is created in BASIC, not just the transform stage. If you were to enter TCL or use the command line in the Administrator, enter the command "VLIST DSD_BP DSD_StageRun.B" and post lines 790-815. I have...

What stage are you using and what is your Oracle instance's default date format?

You need to start at the beginning and take this step-by-step to find the source of the conversion issues.

How are these characters actually stored in Oracle? If you use US7ASCII as your character set then no Arabic characters are representable.

That would explain why the "test" tab has not worked for me - the MQ configuration here is quite restrictive.

vaidehee - in that case I would assume that it does an insert then update and since you don't have a unique key the insert is always successful. How about doing "user-defined insert and update" and then switching the order of the insert and update code, i.e. putting the "update" into the "insert" st...

I forgot to add that MQJExporer is a java app that doesn't need to be installed.

No, not in DataStage; this is an MQ client issue - DataStage only wants to know the queue manager name and the client takes care of the rest. This is like Oracle connectivity where the connection details are in the "tnsnames.ora" file (but in MQ it isn't quite as simple, and I don't know where I wou...

The implicit sort lets you choose key and order. Add a sort stage to your designer canvas and check which options you can specify there to see the difference.

I have to chuckle about "using this site before contacting support" since that is what I do as well; much of the time I find the answers to my questions here while support responds back with "we will look into this". Of course DSXChange can't be used in lieu of support since there aren't too many bu...