DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 116 matches
Author Message
 Topic: Parse Oracle Function with Dataset
pavans

Replies: 1
Views: 910

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 13, 2015 4:54 am   Subject: Parse Oracle Function with Dataset
DataStage® Release: 9x
Job Type: Parallel
OS: Windows
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 l ...
 Topic: Capture Multiple changes
pavans

Replies: 3
Views: 2519

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 17, 2014 8:52 am   Subject: Capture Multiple changes
DataStage® Release: 9x
Job Type: Parallel
OS: Windows
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 2 ...
Resolved
 Topic: Job Parameter Value Assignment
pavans

Replies: 9
Views: 2611

PostForum: General   Posted: Tue Oct 14, 2014 5:01 am   Subject: Re: Job Parameter Value Assignment
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.
Resolved
 Topic: Job Parameter Value Assignment
pavans

Replies: 9
Views: 2611

PostForum: General   Posted: Tue Oct 14, 2014 4:19 am   Subject: Re: Job Parameter Value Assignment
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 Par ...
Resolved
 Topic: Job Parameter Value Assignment
pavans

Replies: 9
Views: 2611

PostForum: General   Posted: Mon Oct 13, 2014 8:39 am   Subject: Re: Job Parameter Value Assignment
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. Sad

Do you think I should ...
Resolved
 Topic: Job Parameter Value Assignment
pavans

Replies: 9
Views: 2611

PostForum: General   Posted: Mon Oct 13, 2014 7:36 am   Subject: Job Parameter Value Assignment
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
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 ...
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Mon Jul 16, 2012 8:59 am   Subject: dsjob syntax error
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 sam ...
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Mon Jul 16, 2012 8:21 am   Subject: dsjob syntax error
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 ...
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Mon Jul 16, 2012 7:17 am   Subject: dsjob syntax error
Ok. I did below:

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

-param "p_runtime=$runtime"

Still It says Invalid args.
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Mon Jul 16, 2012 6:40 am   Subject: dsjob syntax error
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 Argu ...
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Fri Jul 13, 2012 7:53 am   Subject: dsjob syntax error
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.

Thank ...
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Fri Jul 13, 2012 7:31 am   Subject: dsjob syntax error
In other words, incorrect. Please (re)read my post. ...

Ok.
What you mean is that the value for -param $runtime should be '2012-07'?
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Fri Jul 13, 2012 7:25 am   Subject: dsjob syntax error
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 ...
Resolved
 Topic: dsjob syntax error
pavans

Replies: 14
Views: 5321

PostForum: General   Posted: Fri Jul 13, 2012 6:33 am   Subject: dsjob syntax error
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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/I ...
 Topic: Heirarchy Logic
pavans

Replies: 14
Views: 3776

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 28, 2010 7:35 am   Subject: Heirarchy Logic
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.

Data ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours