DSXchange

Hi All,

In one of the interviews, my friend was asked to explain the options available with DS Server and DS Admin. He was not able to crack them. Can u guys shed some light on these questions.

Thanks,
Sumesh

It worked!! Thanks Smruti.

Hi All,

I've an input value which is numeric. I want to check whether the third digit of the input is 1 or not using the derivation. Which DataStage function can be used for this. As per my knowledge, DataStage has many string functions, but how to work with a numeric input.

Thanks,
Sumesh

Hi All,

I've a job which uses a look up, stage variable, a derivation and a constraint. What would be the order of execution for these when the job is run on DataStage Server.

Thanks,
Sumesh

Hi Sonal,
Thanks for the reply.

Do u mean to say that other than writing a shell script, no direct commands are available?

Hi All,

I'm unable to search the forum. So I'm posting it.

How can all the jobs in a project be ran from command line. Can dsjob or dsadmin commands do it?

Thanks,
Sumesh

Thanks. But, when i use the following inputs output is not correct. Input: -1234. Output :0000000-1234.00000 Similiarly 1234:1234.00000 Why the negative sign is coming after zeros? For positive number the output is not correct. -12345678901234:0-12345678901234.0 For long input the output is not prop...

Hi All, I'm reading a record from a sequential file which has a numeric value. For eg: If the input is a negative number as -123456, the output should be -00000123456.00000(11 digits after '-' sign and five digits after decimal point). If the input is a positive number as 123456, the output should b...

Hi All, When i tried to export a DS category using DS Manager(Selection by category in Options Tab), i'm facing some problems. It shows an error as below Error calling subroutine *DataStage* DSR_SELECT (Action=7);Check DataStage is set up correctly in project Test. (Subroutine failed to complete suc...

Guys,
Thanks for the replies

Hi All,

I'm using DataStage 7.0. When i use a Stored Procedure stage, the Database vendor drop down contains only Oracle. It doesn't have DB2 and Sybase listed. Please let me know the problem and possible solutions.

Thanks,
Sumesh

Kumar, Thanks for the reply. I'm getting the records from the stored proc and finds the count by aggregator and stores the count in a hash file. So when stored proc returns zero records, zero rows will be passed from the ODBC stage and hence the hash file will be empty. When this hash file is used f...

Hi All, I've a DataStage job which uses an ODBC stage to call a stored procedure and the count of the records is stored in a hash file. This hash file is looked up in a second job which calls a routine for some functionality. If the stored procedure doesn't reurn any records, the hash file will be e...

What does IPC mean?. Can u be more specific?

Hi all, I am trying to use change capture in my job,i have connected two datasets to change capture and one dataset as output but the problem is i am gettin an warning like this can u just give me a solution Warnning Message: Change_Capture_11: When checking operator: Defaulting "AccountType&qu...