Search found 2886 matches

by qt_ky
Tue Sep 01, 2020 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Processing
Replies: 1
Views: 10204

Please explain what you mean by "process the file." Are you stuck? Do you have a question?
by qt_ky
Sun Jul 12, 2020 5:49 am
Forum: General
Topic: Export/Import environment variables from the command line
Replies: 2
Views: 11578

I consider creating environment variables one by one a manual process. The export and import options in the Administrator client save a lot of time. That's the method we are using to migrate now. It's pretty simple work to do and is only done once per project. The dsadmin command line tool may have ...
by qt_ky
Sun Jun 21, 2020 4:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot delete file and Change refresh interval
Replies: 2
Views: 11409

2. Go to Director, Tools menu, Options, General tab to find the refresh interval settings.
by qt_ky
Sun Jun 21, 2020 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Status compiled
Replies: 1
Views: 10484

See if this helps or offers clues. You may need to contact IBM Support about it.

When running DataStage jobs, the status stayed in compiled status and nothing was written to the job log
https://www.ibm.com/support/pages/node/161757
by qt_ky
Thu May 21, 2020 11:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do you ingest your data into datalake, ...?
Replies: 3
Views: 12578

Our place does not have any of those technologies, but have you tried the File connector stage?

https://www.ibm.com/support/knowledgece ... arent.html
by qt_ky
Mon May 11, 2020 5:24 am
Forum: IBM QualityStage
Topic: need Impact Analysis data stage jobs if the DB name changed
Replies: 5
Views: 14038

Please read Ernie's reply up above. The answers are there.
by qt_ky
Thu May 07, 2020 6:30 am
Forum: IBM QualityStage
Topic: need Impact Analysis data stage jobs if the DB name changed
Replies: 5
Views: 14038

Or if the database name is indeed changing, you could opt to update the pointer to the database on the DataStage server so that the physical database name changes to match the new name, but the database alias keeps the old name, in which case you don't have to change anything else.
by qt_ky
Mon Mar 16, 2020 9:27 am
Forum: General
Topic: Connecting SQL Server DB through Windows Authentication
Replies: 1
Views: 11394

Not sure why. Have you verified outside of this tool if the same credential connects OK using SQL Server Management Studio? Ours works but I am using a different driver (VMsqls00.so). Just for kicks, can you try one with this driver? Below is the entire driver entry; no other properties are required...
by qt_ky
Sun Feb 16, 2020 11:06 am
Forum: General
Topic: IBM Cloud Pak & Information Server
Replies: 1
Views: 10722

At this point we don't have enough information to consider a cloud pak. Are you already using it? I found this pricing web page: https://www.ibm.com/cloud/information-server/pricing For Info Server Enterprise Edition, there's not much detail. Just small, medium, and large with different prices, much...
by qt_ky
Wed Feb 05, 2020 2:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Routines to do EReplace Function
Replies: 7
Views: 7460

Try using a single Convert() function call to replace all of the EReplace() function calls. https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/r_deeref_String_Functions.html Also in the Transformer stage you can do a multiple find and replace of the...
by qt_ky
Sun Feb 02, 2020 2:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help on Transformer Looping
Replies: 5
Views: 6401

That does not make any sense. Have you tried experimenting?
by qt_ky
Wed Jan 29, 2020 5:48 am
Forum: General
Topic: Datastage Client Install issues
Replies: 3
Views: 12867

Ever since Windows 10 we have faced the same issue. You have to run "setup.exe -force" and you will still get the warning but there will be a box you can check that says ignore warnings and continue anyway.
by qt_ky
Tue Jan 28, 2020 4:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Jobs is not seeing compiled when imported to prod
Replies: 2
Views: 4707

What version are you on? We ran into an issue on version 11.3.x. Not sure if this might be related to your issue or not, but it was unusual and took a fair amount of time to debug. It's similar in that if we recompiled, then the jobs would always run fine, but if we had changed an encrypted job para...
by qt_ky
Tue Jan 21, 2020 3:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Infosphere Reference Data Management Hub Data load
Replies: 2
Views: 4106

I saw an IBM RDM stage in DataStage demonstrated at the IBM Insight 2014 conference (in 2014). Check with IBM.