DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 2900 matches
Author Message
 Topic: Loop sequential job reading an input file
qt_ky

Replies: 3
Views: 528

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 15, 2020 2:55 am   Subject: Loop sequential job reading an input file
Yes, I will assume you meant to say the "Server Job" type. In the Transformer stage, you can find a derivation under the Utilities category (if I recall correctly). There will be a function named some ...
 Topic: Datastage 11.5 Bigdata integration
qt_ky

Replies: 3
Views: 263

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 15, 2020 2:53 am   Subject: Datastage 11.5 Bigdata integration
Go to ibm.com and search on "LI docs" (license information documents).

Here is a link to search within LI docs (the URL may change in the future).

https://www-03.ibm.com/software/sla/sladb.nsf/s ...
 Topic: File Processing
qt_ky

Replies: 3
Views: 766

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 01, 2020 3:30 am   Subject: File Processing
Please explain what you mean by "process the file." Are you stuck? Do you have a question?
 Topic: web services transformer stage generating huge log
qt_ky

Replies: 2
Views: 563

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Aug 02, 2020 5:23 am   Subject: web services transformer stage generating huge log
Contact IBM Support.
 Topic: Export/Import environment variables from the command line
qt_ky

Replies: 2
Views: 474

PostForum: General   Posted: Sun Jul 12, 2020 5:49 am   Subject: Export/Import environment variables from the command line
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 ...
 Topic: Cannot delete file and Change refresh interval
qt_ky

Replies: 2
Views: 799

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jun 21, 2020 4:30 am   Subject: Cannot delete file and Change refresh interval
2. Go to Director, Tools menu, Options, General tab to find the refresh interval settings.
 Topic: Status compiled
qt_ky

Replies: 1
Views: 857

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jun 21, 2020 4:27 am   Subject: Status compiled
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://ww ...
 Topic: How do you ingest your data into datalake, ...?
qt_ky

Replies: 3
Views: 1576

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 21, 2020 11:24 am   Subject: How do you ingest your data into datalake, ...?
Our place does not have any of those technologies, but have you tried the File connector stage?

https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.7.0/com.ibm.swg.im.iis.conn.filecon.usage.doc/t ...
 Topic: need Impact Analysis data stage jobs if the DB name changed
qt_ky

Replies: 5
Views: 1126

PostForum: IBM QualityStage   Posted: Mon May 11, 2020 5:24 am   Subject: need Impact Analysis data stage jobs if the DB name changed
Please read Ernie's reply up above. The answers are there.
 Topic: need Impact Analysis data stage jobs if the DB name changed
qt_ky

Replies: 5
Views: 1126

PostForum: IBM QualityStage   Posted: Thu May 07, 2020 6:30 am   Subject: need Impact Analysis data stage jobs if the DB name changed
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 databa ...
 Topic: Connecting SQL Server DB through Windows Authentication
qt_ky

Replies: 1
Views: 990

PostForum: General   Posted: Mon Mar 16, 2020 9:27 am   Subject: Connecting SQL Server DB through Windows Authentication
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 kick ...
 Topic: IBM Cloud Pak & Information Server
qt_ky

Replies: 1
Views: 967

PostForum: General   Posted: Sun Feb 16, 2020 11:06 am   Subject: IBM Cloud Pak & Information Server
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 Ser ...
Resolved
 Topic: Routines to do EReplace Function
qt_ky

Replies: 7
Views: 1813

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 05, 2020 2:18 am   Subject: Routines to do EReplace Function
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_d ...
Resolved
 Topic: Help on Transformer Looping
qt_ky

Replies: 5
Views: 1609

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Feb 02, 2020 2:34 am   Subject: Help on Transformer Looping
That does not make any sense. Have you tried experimenting?
 Topic: Datastage Client Install issues
qt_ky

Replies: 3
Views: 1086

PostForum: General   Posted: Wed Jan 29, 2020 5:48 am   Subject: Datastage Client Install issues
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 a ...
 

 Jump to:   



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