DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 658 matches
Author Message
 Topic: Boomi vs DataStage
FranklinE

Replies: 1
Views: 27

PostForum: General   Posted: Fri Apr 20, 2018 1:28 pm   Subject: Boomi vs DataStage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Comparing the two to each other
Note: I searched DSXchange already, and found no posts that reference Boomi.

Basically, I'm looking for a side-by-side comparison, but not at any great level of detail. I've looked at the Dell mate ...
 Topic: Run and complete a DataStage Job based on a value in a table
FranklinE

Replies: 12
Views: 133

PostForum: General   Posted: Thu Apr 19, 2018 1:33 pm   Subject: Run and complete a DataStage Job based on a value in a table
Vicky, all I can say is that you have Mainframitis, and it might be incurable.

First, manual updates to production being rather, ahem, unusual, they should at least apply some discipline and do the ...
 Topic: Run and complete a DataStage Job based on a value in a table
FranklinE

Replies: 12
Views: 133

PostForum: General   Posted: Thu Apr 19, 2018 10:06 am   Subject: Run and complete a DataStage Job based on a value in a table
Vicky,

A hypothetical job flow:

Job1 -- Query for update to system date in db table. Loop conditions: if not found, wait five minutes and try again. If found, end and release next job to run.
...
 Topic: Run and complete a DataStage Job based on a value in a table
FranklinE

Replies: 12
Views: 133

PostForum: General   Posted: Wed Apr 18, 2018 2:43 pm   Subject: Run and complete a DataStage Job based on a value in a table
Craig has good suggestions. I wonder about whether your jobs run in isolation, or if you have a scheduling application like Control-M to manage the jobs. If, for example, there was a scheduled job whi ...
 Topic: File Pattern When File Name Contains Quotes
FranklinE

Replies: 3
Views: 85

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 18, 2018 12:32 pm   Subject: File Pattern When File Name Contains Quotes
Single quote is a valid character in the file name, but it has a meaning and usage in DataStage. You can't work around that, so you have to change the file name.

I suggest a script which lists the ...
 Topic: COBOL File Issues
FranklinE

Replies: 3
Views: 117

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 11, 2018 9:30 am   Subject: COBOL File Issues
Craig, the server is not happy. My post took a couple of minutes to be saved and displayed. Indeed, I expect this post to be visible sometime in the year 2022. Laughing
 Topic: COBOL File Issues
FranklinE

Replies: 3
Views: 117

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 11, 2018 9:20 am   Subject: COBOL File Issues
Many issues you'll face with Cobol data is covered in the FAQ linked at the bottom of my post.

I believe you are looking at a signed numeric field. The data is alphanumeric, but the digit with the ...
 Topic: MOVE Datastage jobs from one folder to another
FranklinE

Replies: 7
Views: 174

PostForum: General   Posted: Mon Apr 09, 2018 9:02 am   Subject: MOVE Datastage jobs from one folder to another
I just completed a total restructuring of the folders in a project with more than 600 design objects -- sequence and parallel. I did it manually, knowing that any other method had some risks for the p ...
Resolved
 Topic: Setting global variable from job?
FranklinE

Replies: 10
Views: 251

PostForum: General   Posted: Thu Mar 29, 2018 1:48 pm   Subject: Setting global variable from job?
Prepare for possible embarrassment I've felt many times. Wink

What is the Default Value of $APT_LASTDATEPROCESSED in the job you run?

If it's not $PROJDEF, there's your problem.
Resolved
 Topic: Setting global variable from job?
FranklinE

Replies: 10
Views: 251

PostForum: General   Posted: Thu Mar 29, 2018 12:41 pm   Subject: Setting global variable from job?
Ah. Looks like a timing issue. The difference between us appears to be that updating the env variable(s) happens before any jobs that use them are invoked. The gap in timing for us is often hours, dep ...
Resolved
 Topic: Setting global variable from job?
FranklinE

Replies: 10
Views: 251

PostForum: General   Posted: Thu Mar 29, 2018 9:08 am   Subject: Setting global variable from job?
it seems the value does not update until the project is reloaded.

This is a bit mysterious to me. When we run env updates -- always in batch mode, I should point out -- we don't go through a "reloa ...
Resolved
 Topic: Setting global variable from job?
FranklinE

Replies: 10
Views: 251

PostForum: General   Posted: Wed Mar 28, 2018 2:17 pm   Subject: Setting global variable from job?
Unfortunately, you will need to add the variable to every job that needs it. However, if you already have a variable or parameter in place (in a User Variable stage, perhaps) you can value it with the ...
Resolved
 Topic: Setting global variable from job?
FranklinE

Replies: 10
Views: 251

PostForum: General   Posted: Wed Mar 28, 2018 11:28 am   Subject: Setting global variable from job?
I'm not clear on how you want to implement it. Do you want the variable value updated for every cycle, or as a one-time task?

Either way, invoking this dsadmin command for environment variables sho ...
 Topic: Connecting to Designer/Director from command line
FranklinE

Replies: 6
Views: 207

PostForum: General   Posted: Wed Mar 28, 2018 8:07 am   Subject: Connecting to Designer/Director from command line
The only way to be sure is to use a "robot", automated keystroke routines that replace the user actions. We are using Blue Prism for similar work, replacing high-volume, repeated user activity (like a ...
Resolved
 Topic: STRING to Packed hexadecimal
FranklinE

Replies: 14
Views: 665

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 20, 2018 8:59 am   Subject: STRING to Packed hexadecimal
Jagan had trouble composing his questions, and there's no fault to him for that. Nine-tenths of support is getting the right questions asked, and I've been on both sides of that challenge many times.
 

 Jump to:   



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