DSXchange

I have a QualityStage frequency generation job with input of 10 columns and one of them is vector column. When I run the job I get following error. Appreciate your suggestions. Thanks. ---------------------------------------------------------- Match_Frequency_2: Field Owner_NameArray is a vector fie...

Hello, how to convert PST (Pacific time) to GMT?

Thanks for sharing.

Getting this error on FTP Entrprise stage - processing failed for output /tmp/aptfc2.11240.4bd0572b.0, $pftpFifoConn: exit status = 255

any idea?

Thanks.

Thanks for the replies. I am returning ROWCOUNT from stored procedure but I am not sure how to read this in stored procedure stage I see a PARAMETER page in stored procedure stage but not sure how to define it? what should be the values for following - 1. Map to Columns = 2. Parameter marker/literal...

This is output stage.

Job structre is as follows -
Sequential File stage as Input ----> Stored Procedure stage as output.

Hello, I am using stored procedure stage to call a stored procedure. It is working as expected. But now I want to perform the logic as - IF number of records returned by stored procedure = 0 THEN send email notification and abort the job. How to find number of rows returned by stored procedure in Da...

Hello, I am also getting same error for any job in random.

Any further suggestions or solutions?

Thanks in advance.

Calling it as -

In ODBC stage -> Before SQL -> exec Test_StoredProc

I have a DataStage job which is calling stored procedure using ODBC stage. Job is executing- no errors but its not committing the records in database table. When I execute the stored procedure on SQL server directly then all the rows are inserted in table.

Would appreciate your suggestions.

Thanks.

Trigger is not changing the value of command output. So still the same problem.

I tried it and I am getting error -

Loop final value not numeric (Convert(@FM,"",2) - cannot execute

I have a numeric loop. Loop end value is based on the number value in the .txt file I have a execute command stage to read the value from the .txt file. Execute command stage is having line this - cat test.txt e.g. if this file is having the number 10, loop should be executed for 10 times. in the lo...

I am trying to do weight override using conditional data source value.

e.g. FileA -> Name = 'A' then AW = 50, DW = -50

How to put the condition to do weight override?

Would appreciate sharing any ideas.

Thanks.

I have a sequence which is having wait for activity as one of stages. Sequence is having exception handler and terminiator. Wait for file activity keeps on checking for the file every 1 minute. After the first 1 minute wait for file activity, sequence is going to terminator and getting aborted. Log ...

Ray, thanks again for your response. your script is having a note * Note - does not handle execution through midnight. For my requirement - We start the DataStage process then it will go in wait mode for over night as the file will be coming in next day on week days. Weekend will be skipped, so it w...