DSXchange

I tried to use CALL instead of EXEC to run the stored procedure (in ODBC connector) and unfortunately that did not work either.

Yes, that is correct, it was a typo. I meant that "does NOT perform the required activity".

The version that I have is 11.5.0.2.

Unfortunately not getting a clue on why the job behaves like this.

Thanks.

Hi, Hope all are doing great. We migrated 8.5 version of jobs (Unix env.) to 11.5 version (Linux env.) recently. We are having trouble with a job that is executing a SQL Server stored procedure from ODBC connector. The same job runs fine in 8.5 but in 11.5 job completes but does perform the required...

Thanks chulett and Ray.

In the execute command activity, it is just cat <filename> and text file is created in prior step with 2 columns delimited with comma.

So, do I need to add @FM for each column in the FIELD function?

Please advise.

Thank you.

Hi, Basically we are trying to generate and extract when the run flag is "YES" and process type is "A" (or) "YES" and process type is "M" (or) "NO" and process type is "M". Step 1 - An output text file is created with 2 columns and delimite...

Hi, Had done the installation of Datastage 8.5 version (on Windows 7) and it worked fine, later when the patch (fix pack 3) was installed, it did not go through fine. No error messages were returned, it just came out. When tried to uninstall Datastage the following error was thrown. java.io.IOExcept...

Hello, I have a parallel job that executes a SQL Server stored procedure as source and it returns an output of few columns. One of the columns is STATUS which is hardcoded (data type is varchar)in the procedure and that is returned but when the job is run got the following warning. The target data t...

Thanks stephan.zahariev

Yeah, I tried using sql server stored procedures, it does work fine.

Actually when I use the ETL to run the stored procedure, it aborts and the procedure does not run fine. When I run the procedure manually on sql server it runs fine.

Thanks

Hi ArndW,
The '#' was just a temp table inside the procedure and not a parameter.

Hi stephan.zahariev
Can you please let me know how I can use SQL Server Profilier from Datastage?

Thanks

Hi, We actually execute a sql server stored procedure through a Datastage job and to capture the output of the procedure. The procedure on successfull execution would return 0 else -1 and return mesage either 'Success' or 'Failed' ie. 2 output paramenters from the procedure. We the Datastage job is ...

Thanks Ray for the suggestion, it works fine.

Hi, We have an issue in way we get the records in a output sequential file in parallel job and the design is straight forward. We have a 3 step validation for input records (from sequential file), first step is to validate column A and if it fails the record goes on to a reject file and if it pass g...

Thanks times29 and chulett, the warning did not come up after adding the env. variable.

Thanks for the help.

Did search and found that I can try by setting the environment variable DS_NO_PROCESS_METADATA=1

Is this something I need to add to user-defined in the DS Admin project property?

Thanks

Hi, The job is fairly simple and straight forward as, oracle stage -> stored procedure stage Here only 1 value (date) is returned from oracle stage and it is passwed to STP stage as input to the procedure, executes the stored procedure which is in Sybase. If the procedure is executed manually it wor...