Search found 24 matches

by WBlaustein
Mon Jul 16, 2018 11:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: $Apt_disable_combination
Replies: 4
Views: 8251

Re: $Apt_disable_combination

Why not just post the link to the IBM documentation, which also does not answer the question as to "WHY".
by WBlaustein
Fri Mar 08, 2013 12:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC connection to DB2 which is server encrypted
Replies: 1
Views: 1250

ODBC connection to DB2 which is server encrypted

Was this issue resolved ?
if so where is the resolution ?

I have similar issue.
I was able to connect to DB2 database via odbc.ini where DB is not server encrypted.

but I was not able to connect to DB2 database via odbc.ini where DB is server encrypted.
by WBlaustein
Mon Feb 25, 2013 5:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input Stage Error While parsing the XML document
Replies: 3
Views: 3701

Thanks for the response Erine. I have checked the column content as "XML Document" only at the time of job creation itself. The issue that I observed was with the schema file location at which the document is pointing to. The below given is the Root Element of my XML Document and as you ca...
by WBlaustein
Fri Feb 22, 2013 5:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input Stage Error While parsing the XML document
Replies: 3
Views: 3701

XML Input Stage Error While parsing the XML document

Hello All, I am having a problem while parsing the data from a XML column. my job looks like this DataSet1--->XML Input Stage---->Dataset2 my XML data is in a column in Dataset1 I included the namespace declaration for the XML Input Stage. I haven't checked the "validate input XML" checkbo...
by WBlaustein
Tue Feb 12, 2013 7:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Message Queue Replication
Replies: 1
Views: 1296

DB2 Message Queue Replication

Had a requirement to load data into DB2 and MessageQueue at the same time. Incase if any one of them aborted the other one has to Rollback as well.
by WBlaustein
Wed Jun 20, 2012 9:46 am
Forum: General
Topic: Can DataStage search for a Pattern of Files in Sub-Direcotor
Replies: 10
Views: 5507

But How can we pass that path?
I tried to use External Target Stage. The Path location is stored in a column.
by WBlaustein
Tue Jun 19, 2012 5:16 pm
Forum: General
Topic: Can DataStage search for a Pattern of Files in Sub-Direcotor
Replies: 10
Views: 5507

How to do that! While i was writing to database how can i move the files from source to archive directory!! Example: If my source file has 10 absolute paths: iis/data/f1/1.xml iis/data/f2/2.xml while loading the 1.xml into the database how can we move the same file at the same time to another locati...
by WBlaustein
Tue Jun 19, 2012 12:22 pm
Forum: General
Topic: Can DataStage search for a Pattern of Files in Sub-Direcotor
Replies: 10
Views: 5507

I wrote a small Script to do that (Moving files to Archive).
I am wondering is there any way to move the files while loading into the table??
by WBlaustein
Fri Jun 15, 2012 11:50 am
Forum: General
Topic: Can DataStage search for a Pattern of Files in Sub-Direcotor
Replies: 10
Views: 5507

I used the Find command to print all the XML files in the sub directories and redirect that output to a textfile and from that text file I am able to read those XML files too. BUT Any one can tell me the Move command to move those files that are present in the text file?? text files content /IIS/dat...
by WBlaustein
Fri Jun 15, 2012 9:32 am
Forum: General
Topic: how to callback to DS to get its Recent job ouput
Replies: 5
Views: 2942

Standard output ( eigther in a text file or in command line) purpose is to When ever a job successfully completed we need to store those logs in Tivoli Scheduler Repository for the associated job.
by WBlaustein
Fri Jun 15, 2012 9:27 am
Forum: General
Topic: Can DataStage search for a Pattern of Files in Sub-Direcotor
Replies: 10
Views: 5507

I dont have any preferred mechanism. My job is to read those xml files and load its content to a database and after successfull completion of Loading, i have move those files to arcive directory.
by WBlaustein
Thu Jun 14, 2012 5:16 pm
Forum: General
Topic: Can DataStage search for a Pattern of Files in Sub-Direcotor
Replies: 10
Views: 5507

Can DataStage search for a Pattern of Files in Sub-Direcotor

Hello Everyone, I have a scenario, In the Input folder we will have dynamic sub folders with XML Files. My questions is How can we read those xml files in the dymaic sub folders. Ex: input/061212/ ---this has 15 files input/0613/12/ -- this has 20 files I want to read all these 35 files from Datasta...
by WBlaustein
Thu Jun 14, 2012 10:22 am
Forum: General
Topic: how to callback to DS to get its Recent job ouput
Replies: 5
Views: 2942

Can you Explain me in more Details!!!
How to call that DSJ.ME function in After/Before Job Rioutines, i didn't seen those king of routines in that drop down list.
by WBlaustein
Wed Jun 13, 2012 9:46 am
Forum: General
Topic: how to callback to DS to get its Recent job ouput
Replies: 5
Views: 2942

how to callback to DS to get its Recent job ouput

Hello Everyone,
I have a scenario, whenever my job finishes it execution it has to output its Log (with any warning or Errors exitsts in that job). How to achieve this?
by WBlaustein
Wed May 30, 2012 2:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mapping in XML Stage
Replies: 2
Views: 2778

Mapping in XML Stage

Hello, My job Scenario is I am trying to Map an XML file in one schema to another Schema by using XSLT. the job is running successfully but the output is populated with different elements ( which are mandatory columns that are defined in the schema). I am passing that as a String Job Design XML Stag...