DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 144 matches
Author Message
 Topic: Dynamic Parameter
jackson.eyton

Replies: 1
Views: 1351

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 07, 2020 6:25 am   Subject: Dynamic Parameter
I don't believe this is possible directly within a parallel job. I do this using Sequence jobs and UserVariable Activity stages. From what I understand of your need, you'd want a parallel job that per ...
 Topic: Identify Trouble Column on Transform Error
jackson.eyton

Replies: 0
Views: 1199

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 01, 2020 1:26 pm   Subject: Identify Trouble Column on Transform Error
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi guys, I feel like I must be missing something here. I have some files that I am bringing in from a CSV, due to datastage's quirks we bring in all fields as VarChar initially then transform them in ...
 Topic: Cognos 11.1.3 page load speed issue
jackson.eyton

Replies: 0
Views: 2551

PostForum: Cognos (IBM BI)   Posted: Thu Jul 18, 2019 10:15 am   Subject: Cognos 11.1.3 page load speed issue
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi everyone, figured I would ask here in case someone has run into this. I do have an open ticket with IBM as well so if they find anything I will update this for everyone. Basically we have an issue ...
 Topic: Sequential(CSV) file structure validation?
jackson.eyton

Replies: 5
Views: 1883

PostForum: General   Posted: Thu Jun 27, 2019 5:12 pm   Subject: Sequential(CSV) file structure validation?
Looks like CSV Lint might work. I was considering writing my own, may still do that but I will research some other tools that already exist first.

https://csvlint.io/
 Topic: Sequential(CSV) file structure validation?
jackson.eyton

Replies: 5
Views: 1883

PostForum: General   Posted: Thu Jun 20, 2019 1:33 pm   Subject: Sequential(CSV) file structure validation?
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi,
I have a potential issue I am hoping to circumvent before it happens (matter of time). We have a few external sources that we have to bring in from sequential files. The issue is that a few of th ...
Resolved
 Topic: Include = sign in Execute Command argument list?
jackson.eyton

Replies: 3
Views: 1244

PostForum: General   Posted: Tue Jun 18, 2019 11:23 am   Subject: Include = sign in Execute Command argument list?
Laughing

As an update, looks like we got it, not sure why it wouldn't work via the Command Execute stage but worked fine in a native command prompt. The fix was to adjust the bat file itself as follow ...
Resolved
 Topic: Include = sign in Execute Command argument list?
jackson.eyton

Replies: 3
Views: 1244

PostForum: General   Posted: Mon Jun 17, 2019 6:31 pm   Subject: Include = sign in Execute Command argument list?
DataStage® Release: 11x
Job Type: Server
OS: Windows
Good afternoon everyone, I am having an issue using an Execute Command stage in a sequence job. Scenario is that I have a bat file I need to call and pass a series of arguments to it. The problem chil ...
 Topic: DataStage Job Reports 403
jackson.eyton

Replies: 2
Views: 818

PostForum: General   Posted: Tue Apr 30, 2019 10:36 pm   Subject: DataStage Job Reports 403
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi Everyone,
I am in the process of documenting our nightly processing jobs into a wiki and I wanted to include links to the DataStage generated reports for the jobs. I create the reports and I ca ...
Workaround Reported
 Topic: DataQuality Notifications for invalid data
jackson.eyton

Replies: 3
Views: 1035

PostForum: General   Posted: Tue Jan 29, 2019 7:17 am   Subject: DataQuality Notifications for invalid data
Thanks Ray! I have been looking into this for some time now. Part of an issue I have is that it appears our IA setup might have some issues. I am working with IBM on that but in the meantime I was hop ...
Workaround Reported
 Topic: DataQuality Notifications for invalid data
jackson.eyton

Replies: 3
Views: 1035

PostForum: General   Posted: Fri Jan 18, 2019 12:01 pm   Subject: DataQuality Notifications for invalid data
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi Everyone!

I wasn't sure where to put this so into General it goes.

We are looking to implement some awareness of some kind in regards to Data Quality. One example of our issues: we have ...
Workaround Reported
 Topic: Job Sequence: Downgrade warning message to info?
jackson.eyton

Replies: 8
Views: 1880

PostForum: General   Posted: Wed Nov 28, 2018 2:34 pm   Subject: Job Sequence: Downgrade warning message to info?
Ok, I did some more research and ended up just creating a sequence that calls the DSSendMessage routine straight up. I have a couple of UserVariables Activity stages that are used to build the message ...
Workaround Reported
 Topic: Job Sequence: Downgrade warning message to info?
jackson.eyton

Replies: 8
Views: 1880

PostForum: General   Posted: Wed Nov 21, 2018 6:24 am   Subject: Job Sequence: Downgrade warning message to info?
Which that may have been our issue all along for that. Many of our jobs are OK to continue if they finish with warning, and I believe the biggest thing was running through sequence logic with the jobs ...
Workaround Reported
 Topic: Job Sequence: Downgrade warning message to info?
jackson.eyton

Replies: 8
Views: 1880

PostForum: General   Posted: Tue Nov 20, 2018 7:24 am   Subject: Job Sequence: Downgrade warning message to info?
No problem at all, I appreciate the discussion! Any particular reason to use DSJS over the actual job codes? I only ask as we switched most of our links to use the actual job status code instead of RU ...
Workaround Reported
 Topic: Job Sequence: Downgrade warning message to info?
jackson.eyton

Replies: 8
Views: 1880

PostForum: General   Posted: Mon Nov 19, 2018 2:48 pm   Subject: Job Sequence: Downgrade warning message to info?
That is my understanding as well, but figured I would ask. I don't suppose I could set a link condition to the specific components of a sequence job? So, say I have SequenceA and SequenceB. SequenceA ...
Workaround Reported
 Topic: Job Sequence: Downgrade warning message to info?
jackson.eyton

Replies: 8
Views: 1880

PostForum: General   Posted: Mon Nov 19, 2018 2:05 pm   Subject: Job Sequence: Downgrade warning message to info?
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi everyone,
I have an issue with sequence jobs where we have the notification activity branched off at various points to send a text to us in ETL so we are aware of the nightly running process p ...
 

 Jump to:   



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