Author |
Message |
Topic: Dynamic Parameter |
jackson.eyton
Replies: 1
Views: 1491
|
Forum: 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: 1347
|
Forum: 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: 2763
|
Forum: 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: 2050
|
Forum: 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: 2050
|
Forum: 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 ...
|
Topic: Include = sign in Execute Command argument list? |
jackson.eyton
Replies: 3
Views: 1375
|
Forum: General
Posted: Tue Jun 18, 2019 11:23 am Subject: Include = sign in Execute Command argument list? |
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 ...
|
Topic: Include = sign in Execute Command argument list? |
jackson.eyton
Replies: 3
Views: 1375
|
Forum: 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: 910
|
Forum: 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 ...
|
Topic: DataQuality Notifications for invalid data |
jackson.eyton
Replies: 3
Views: 1160
|
Forum: 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 ...
|
Topic: DataQuality Notifications for invalid data |
jackson.eyton
Replies: 3
Views: 1160
|
Forum: 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 ...
|
Topic: Job Sequence: Downgrade warning message to info? |
jackson.eyton
Replies: 8
Views: 2059
|
Forum: 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 ...
|
Topic: Job Sequence: Downgrade warning message to info? |
jackson.eyton
Replies: 8
Views: 2059
|
Forum: 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 ...
|
Topic: Job Sequence: Downgrade warning message to info? |
jackson.eyton
Replies: 8
Views: 2059
|
Forum: 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 ...
|
Topic: Job Sequence: Downgrade warning message to info? |
jackson.eyton
Replies: 8
Views: 2059
|
Forum: 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 ...
|
Topic: Job Sequence: Downgrade warning message to info? |
jackson.eyton
Replies: 8
Views: 2059
|
Forum: 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 ...
|
|