DSXchange

Have you checked you have the tnsnames.ora file configured correctly on the Datastage server. Are you able to tnsping your database from the Datastage server?

Just received the following from IBM Yes, the table action is executed prior to "Before SQL" statement. This is per design, and I checked the code of two other connectors, and they follow the same design. We cannot change the order as that may introduce regressions for the existing jobs. I...

In the Oracle Connector stage you cannot enter any SQL into the before or after SQL areas until you have said yes.

I have a job that reads data from a source and does an initial load into an Oracle database via the Oracle Connector stage. Before the data can be loaded I need to disable the constraints, so I coded this into the Before SQL section of the page but when I run the job the Before SQL is not running so...

Thanks Rohith...missed that space completely...

Hi Trying to convert a number of '19760109' to a date field in Oracle. When I use the StringToDate function with map of '%yyyy%mm%dd' I get the following error message - APT_CombinedOperatorController,0: Data string ' 1976010' does not match format '%yyyy%mm%dd': an integer was expected to match tag...

If your running in Ver 8, have you tried the 'istools' command shell provided with the client install, it may work a little better. I know I have had problems with scheduled exports and imports, and it seemed to have something to do with the account attached to the scheduled task. This tools may wor...

Anyone have any ideas on this one???

I was starting to worry that I may have offended someone and I had been 'sent to Coventry'...

By using the Admin client tool, and each project seemed to delete as expected, but leaving it in the list.

Has anyone seen this type of behaviour??

Hi When trying to remove some old projects no longer needed I have run into two problems - 1) One of the projects does not appear in the list of projects within the Administrator, but the directory structure till exists on the server. I can 'LOGTO' the project on the TCL, but if I run the commands t...

Try something like -

Fmt(Trim(Out_Agg.OUT),"7'0'R")

:D

(I'm assuming FMT is available in Parallel, I'm not sure, if not sorry I can't help)

Thanks Craig...but I already knew that.

I have tried typing a new invocation id, as well as pasting one from my clipboard, we use a job number for the invocation id. I have to also check this from the command line as this is how we normally run our process end-to-end (Control-M calls DataStage from the unix command line). I will do some a...

Hi Craig If I run from the primary job, it runs without an invocation id, whereas if I use an existing run of the job and try to change the invocation id it uses the existing one. I though it may have to do with the number already used, i.e. I had 10 previous invocation id's, so I cleared the status...