Search found 17 matches

by boolseye
Tue Dec 08, 2015 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parsing help
Replies: 2
Views: 2271

Re: XML Parsing help

Hi eostic,

Thanks for reply.
I was not able to read your answer since it was premium content.

I was able to achieve the goal using xml stage and switch step.

http://www.ibm.com/developerworks/data/ ... index.html

Thanks
by boolseye
Thu Dec 03, 2015 2:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parsing help
Replies: 2
Views: 2271

XML Parsing help

need some help on below sample xml I need to parse an xml and get specific value from repeating element where type is specific. For example <ID>123 <SubGroup> <Type>X</Type> <Value>0.0</Value></SubGroup> <SubGroup> <Type>Y</Type> <Value>1.0</Value></SubGroup> <SubGroup> <Type>K</Type> <Value>0.0</Va...
by boolseye
Wed Nov 04, 2015 1:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to pass arguments in web service client
Replies: 3
Views: 2543

you can use parameters.. i tested a WS call with local parameters and used it in security tab as #pmUserID#
by boolseye
Mon Nov 02, 2015 11:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Call Stored Procedure on iSeries/AS400 System in ODBC Stage
Replies: 5
Views: 3461

Hi Craig .. did you hear back from IBM support on possibility?
by boolseye
Thu Oct 29, 2015 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Call Stored Procedure on iSeries/AS400 System in ODBC Stage
Replies: 5
Views: 3461

i tried colon with inout params earlier.. No luck.. :(
by boolseye
Wed Oct 28, 2015 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Call Stored Procedure on iSeries/AS400 System in ODBC Stage
Replies: 5
Views: 3461

Call Stored Procedure on iSeries/AS400 System in ODBC Stage

Hi, We have requirement to call a stored procedure on iSeries/AS400 system. We are connecting target system via ODBC Stage. The drivers we use to connect is VMdb200.so in .odbc.ini file Issue: We are trying to call a remote store procedure with first 3 as input column and last 2 column as "inou...
by boolseye
Mon Dec 22, 2014 3:13 am
Forum: General
Topic: How to remove a parameter set from all the Jobs
Replies: 2
Views: 1931

Do the where-used analysis and identify jobs
export the jobs in dsx and change the param-sets to other local OR env variables.
by boolseye
Mon Dec 22, 2014 3:07 am
Forum: General
Topic: trigger job only if file exists
Replies: 4
Views: 4052

3 ways
1) file watcher job if you have external scheduler like controlm
2) waitfor file activity stage
3) check the count of directory from job and if it is non-zero then trigger the jobs.
by boolseye
Mon Dec 22, 2014 3:05 am
Forum: General
Topic: Unable to run SSH from DataStage 9.1 on Windows
Replies: 6
Views: 5468

We faced similar problm but for different db.
Just ask the db admins to monitor the session at db end as soon as that script is hit.
This looks like a problem with infrastructure
by boolseye
Mon Dec 22, 2014 2:59 am
Forum: General
Topic: dsjob utility PID not terminating/ending in UNIX environment
Replies: 9
Views: 5456

please fire below command
kill -9 PID
You should have root access or you can ask admins to do that.
by boolseye
Mon Dec 22, 2014 2:57 am
Forum: General
Topic: Datastage 7x to 11x
Replies: 8
Views: 4746

Hi, I would suggest ( if you have the access to newest version then) try to export few jobs from 7.5 and import in 11.
We recently migrated lots of jobs from 7.5, 8.1 to version 9.
by boolseye
Mon Dec 22, 2014 2:52 am
Forum: General
Topic: Running multiple instances of istool at the same time
Replies: 6
Views: 4411

Today I ran almost 3-4 istool import export scripts almost at the same time. Each of the script was reading from one project and writing to another project. I faced only one issue " failed Error exporting design time data: Value '2014-12-19T04:32:01.893-0600' is not legal." I had to find t...
by boolseye
Mon Dec 22, 2014 2:46 am
Forum: General
Topic: istool command -How to import env variable/params?
Replies: 0
Views: 1412

istool command -How to import env variable/params?

I'm planning to use istool for export import since my job number is huge.
Using dsx at the time of importing gives an option to add env variables.
Do we have similar option in istool?

Any help is highly appreciated.
by boolseye
Tue Nov 18, 2014 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe Files, SDK Sequences and Q-Pointers
Replies: 4
Views: 6008

Re: Universe Files, SDK Sequences and Q-Pointers

Although this is pretty old post.. just sharing my recent encounters with Hash files and SDKSequences movement from 75 to 91.. 1) Hash files movement- If the OS are Windows to Linux you are not going to face any challenge but if it is AIX to Linux then you need to call fnuxi command to change the by...
by boolseye
Sun Aug 31, 2014 1:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migrating SDKSequences File
Replies: 5
Views: 5120

I think option 3 of this link deals with the issue...

http://www-01.ibm.com/support/docview.w ... wg21458678

Thanks chulett for help....