DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 660 matches
Author Message
 Topic: Reading encrypted password into user variable
FranklinE

Replies: 2
Views: 17

PostForum: General   Posted: Wed Apr 25, 2018 1:18 pm   Subject: Reading encrypted password into user variable
My experience with this, using environment variables for passwords, involves how the variables are listed and used in the job.

My implementation:
Define the environment variable in the job propert ...
 Topic: Boomi vs DataStage
FranklinE

Replies: 2
Views: 60

PostForum: General   Posted: Mon Apr 23, 2018 10:09 am   Subject: Boomi vs DataStage
I saw that one. 143 Boomi reviews to 14 for DS. Not up to even the minimal statistical standards. Humph.
 Topic: Boomi vs DataStage
FranklinE

Replies: 2
Views: 60

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: 145

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: 145

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: 145

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: 104

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: 125

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: 125

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: 180

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: 254

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: 254

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: 254

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: 254

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: 254

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 ...
 

 Jump to:   



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