DSXchange

Dear All, I have a Oracle function and the result from the below query is: select id, sid, x.leg_rows from table(XXXX.XXXXXXXXXX.XYZZZFULLINFO(systimestamp - 1)) x id sid leg_rows 475387 113905940 (DATASET) 475388 113905940 (DATASET) the leg_rows consists of multiple rows within the dataset correspo...

Hi This is more like fixing the existing data. Source: This is the data I am getting from source. rno, bk, active_frm, active_to ,flag,org ,unit 1, 28023 29/08/2003 05/12/2003 N 25598 25598 2, 28023 06/12/2003 10/12/2003 N 25598 25598 3, 28023 11/12/2003 03/03/2004 N 1697959 1697959 4, 28023 04/03/2...

I was missing a execute command stage in below and the command.
I found it now. To read contents of param file we should use a in command 'type'.

It worked now.

Thank you all for your time.

Yes. The value in the file looks like :

ID=1055

and is located at

F:\IBM\InformationServer\Server\Projects\PRO_NAME\valuefileDB

I created the file at this path rather creating it using Parameter Sets from designer.

I am confused on how to read this file now.

Thank you for the quick reply.

Now I have set First Line is Column Names = True in the job J1.
Keeping all others same, I ran the job and I am getting the same output.

Do you think I should use a Execute Command Activity before Job J2 in the Job sequence?

Hi All, Scenario: My run-id is created by oracle sequence in one job. In subsequent job I need to use this generated value. So the requirement is assigning value of run-id generated in job1 to some variable/parameter and then pass the value to job2. What I did: Step1: 1. Created a parameter set (Say...

Oh my goodness..

I changed the order of -param and -jobstatus and job is running now.
When I searched the forum most of the dsjob syntax had -jobstatus first and then the -param, so I used the same syntax.

Currently I hardcoded the -param value. Let me try with with a variable and get back to you.

So, you didn't actually change the values you are passing in - did you change the parameter type? Please post the full, unedited error message. Also, remove the quotes. ... I am running a JCL which has a Unix Script. Here what I tried now : /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -doma...

Ok. I did below:

runtime=`expr substr $6 1 4``expr substr $6 6 2`

-param "p_runtime=$runtime"

Still It says Invalid args.

I got a little closer as you said. I searched the forum and found that if the parameter is a Date we should enclose it in Single Quotes. I did that. But still I am facing an error saying Invalid Arguments. Now my -param looks like below: -param 'p_runtime=`expr substr $6 1 4``expr substr $6 6 2`' Am...

my bad. its been a tough week and late on friday. sorry for missing it.

so
-param p_runtime=`expr substr $6 1 4``expr substr $6 6 2` should work?

I will get back to you after testing.

Thanks a lot.

chulett wrote:In other words, incorrect. Please (re)read my post. ...

Ok.
What you mean is that the value for -param $runtime should be '2012-07'?

ArndW wrote:does the year/date contain blanks, i.e. "2010 05 20"?
also, could you post an actual command line and the error message? ...

$6 = '2012-07-13 07:00' -- This is coming from a JCL.

runtime=`expr substr $6 1 4``expr substr $6 6 2`

I have tested this and the output is 201207

Hi All, /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -domain $1 -user $2 -password $3 -server $4 -run -paramfile /userdata/Parameters/$7/$5 -jobstatus $7 $8 -- Working Fine /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -domain $1 -user $2 -password $3 -server $4 -run -paramfile /userd...

Yes, what database is this coming from? All these examples and pictures and nary a mention of what database you're working with. May be useful information after all. Thanks for the replies. Database is : SQL Server 2008 Data from database tables: SURR_ID,Status_ID,ID_OVER,ID_UNDER,TYPE_ID, 60001,I,...