DSXchange

I sent the date part as a separate parameter and it worked.
I think datastage does not like
PARAMVALUE=A.date < '2003-10-10'
but it is okay with
PARAM1= A.date<
PARAM2= #datevalue#

Thanks

Just a guess, but have you tried using two single quotes per quote? date < ''2003-10-20'' Note these aren't double-quotes, but two single quotes at each end of the date. Or something else to 'escape' the quotes so they are retained? If you are sure that is the problem, that is... Do you know what e...

I tried two single quotes ..,it removes both of them.
The querry works fine in db2 command center.

Hi I am using the user defined sql option and i am passing the where clause a parameter to the job. db is DB2 Select * from db2.datastage where #WHERECLAUSE# In the above sql the parameter WHERECLAUSE is date <'2003-10-20' But when i am passing this to the sql it is coming out as Select * from db2.d...

Thanks a ton guys!Surely appreciate your valuable suggestions.

You got it right. We gave a script to our configuration management team which checks out,compiles and then imports to a perticular project. Each of our jobs have some dependedent jobs and they are all(Main job + dependent jobs) checked in under one dsx file.Sometimes some of these dependent files ar...

Hi

Is there a way to delete jobs from a Project from the command line.

Thanks!

In my Administrator window,the inactivity timeout is GREY an the do not timeout is also grey .
I dont have anything to click on.

Can anyone pls tell why and how this problem occurs??
Are there any precautions we can take so that these kind of errors dont happen??

How do i clean up.
The way i know is to use DS TOOLS.Do you have any other suggestions.

Thanks!

When i am trying to import a dsx file into a project by the name MDS_SYSTEST0_R44 using the datastage manager i get this error message.Did anyone get this kind of problem before. Error calling subroutine: DSR_WHEREUSED (Action=3); check DataStage is set up correctly in project MDS_SYSTEST0_R44 (The ...

HI Ray

It appears to me that the Value only option of wrapped stage is not working.I did the $0 $1 $2 $3 test and it did not work.
But when i used the Name- Value pair option of wrapped stage it worked.

Most part of it was right.I had to change the way i paese the params in the shell scripts.Due to some reason it cant recognize positional params.

Teej wrote:

deep wrote:I have the solution now..,Thanks!

What was your solution?

-T.J.

I have the solution now..,Thanks! Hi I have a shell script which needs to be called from a wrapped stage. (I have to use the warpped stage b'coz we stream the datasatge data to a c++ program and we call this c++ prog from the shell script) The shell script takes 3 parameters. I created a wrapped sta...

Hi I have a shell script which needs to be called from a wrapped stage. (I have to use the warpped stage b'coz we stream the datasatge data to a c++ program and we call this c++ prog from the shell script) The shell script takes 3 parameters. I created a wrapped stage and i am calling the shell scri...