DSXchange

Hi, Fixed! For your info: I got some compilation errors with the SDWarn, but I used these statements instead: Message1 = DSRMessage("DSTAGE_TRX_I_0005", "<L>*** Output from Ans was: ***<L>", ""):Ans:Ans Call DSLogInfo(Message1, RoutineName) Message2 = DSRMessage("D...

Hi Arnd and Ray, I tried both methods, but the same error occurs for both. Arnd - I added in the trim statement, and I get the same error. Ray - I was in fact running using a sequence already, but I was using a Routine Activity linked to a Job Activity. However I took your advice and changed the rou...

Hi Arnd, My parameter type is string. I think it is probably like you say about stripping off the unwanted characters. Can you give me an example how to do that? Currently I am just using Ans= Trim(Output) Also, I am finding it difficult to output any additional log information so I can see what the...

Thanks for that. I created a custom routine of type transform function, and in the code I set Ans = Output It seems this solved the initial problem, i.e. now I can pass a value, but I have hit another error, which may be to do with datatypes of syntax. The job parameter I am setting is of type Strin...

Hi, First time posting, I had a search around but couldn't find the answer to this one, hope someone can help! I am using the ExecSh routine to run a shell script (which it turns executes sql). The script and routine work correctly, and in the DS Log I see: STGLoadADCQuality..JobControl (ExecSH): Ex...

The manual loading is working though. I guess there some communication problems between DataStage and Oracle via the shared library.

Oli

Hi there I reset the job and only get the very explanatory information (NOT) Job DevFDMxStoreProcessedRecords aborted. Resetting Job DevFDMxStoreProcessedRecords. Resetting stage DevFDMxStoreProcessedRecords..xfmRecords. Finished Resetting stage DevFDMxStoreProcessedRecords..xfmRecords. Job DevFDMxS...

Hi Craig

Yes, the database is located on the same physical machine as the Datastage binaries. It is version 9.2.0.5 but all the jobs I am currently using are using the Oracle 8.1.7 client since I have not yet migrated to the new OCI 9 stage.

BR
OLI

Hi I am experimenting with the Oracle OCI Load Stage using direct path loading and I dont seem to get a simple job to run. It is a simple job with one Oracle Source, Transformer and the OCI Load Stage. I am using the AUTOMATIC load option and hence do not specify any Directory Path Control File Name...

In the latest DataStage Installation Guide there are 2 new kernel parameter configuration recommended, the MAXUPROC and NOFILES. For Solaris the following values are reccommended MAXUPROC - Minimum Value of 100 per CPU NOFILES - Minimum Value 1000 The upgrade/install guide does not state the purpose...

Hi

I am planning an upgrade from DS 5.1 to 7.5 in a Solaris Environment. I wanted to hear if somebody out there had done a similar upgrade and if there were any issues/pitfalls with doing such an upgrade (that is not covered in the upgrade guidlines from Ascential)

Best Regards
Oli, 3 Sweden

Hi there I have one rather simple question (not for me tough). In one of my jobs that had XML pack 1.1 then I stated the output path for the XML files in the XML writer on the format #PROJ##OUTPUT_DIR#/Tre%@.xml The first column was the datestamp so I got the outputfiles Tre20040518.xml, Tre20040518...

There are several files that have a fullstop (a dot ".") at the end of the filename. Rename the server file to server. and try to install again. You will probably get this error message a few times more since there are more files that have a dot at the end of the filename.

This is a server job, not paralell

//OLI

Hi there I am currently upgrading DataStage from 5.1 to 7.1. I just migrated one of my projects to 7.1 and get several compilation errors that I did not get with version 5.1. Within Job Sequences I have I have several routines where I declare variables within the routine, an example is an Error Code...