DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 676 matches
Author Message
 Topic: Run and complete a DataStage Job based on a value in a table
FranklinE

Replies: 13
Views: 597

PostForum: General   Posted: Fri Jun 08, 2018 12:24 pm   Subject: Run and complete a DataStage Job based on a value in a table
I have a further thought around the manual update part. I suggest imposing a technical requirement on the mainframe developers that they accomplish the update with an ESP job. This would eliminate the ...
 Topic: Parameterized password in Stored Procedure stage
FranklinE

Replies: 12
Views: 438

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 23, 2018 12:46 pm   Subject: Parameterized password in Stored Procedure stage
I believe it's that the password is encrypted, and not being converted back to text by the runtime engine. I defer to others who use the SP stage to comment further, because I've hit the extent of my ...
 Topic: Parameterized password in Stored Procedure stage
FranklinE

Replies: 12
Views: 438

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 23, 2018 11:17 am   Subject: Parameterized password in Stored Procedure stage
It could be as simple as a syntax error.

How are you typing in the Data source and user name? Do you just name the parameter -- parmDataSource -- or are you using the escape # -- #parmDataSource#? ...
 Topic: CFF Stage
FranklinE

Replies: 2
Views: 309

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 22, 2018 7:37 am   Subject: CFF Stage
I recently posted a FAQ about CFF. The link to the post is at the bottom of this post. Read about editing the copybook before loading it with the Import Wizard.

Occurs depending and groups are defi ...
 Topic: Inhibiting sequence/job execution
FranklinE

Replies: 3
Views: 210

PostForum: General   Posted: Tue May 15, 2018 7:43 am   Subject: Inhibiting sequence/job execution
Disciplined, or punished? Razz

I tell my infrastructure support people that they have two choices: do some planning and announce any "outage" in advance, or watch me do a verbal scorched earth rout ...
 Topic: How to generate warnings when rows rejected
FranklinE

Replies: 4
Views: 402

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 04, 2018 8:28 am   Subject: How to generate warnings when rows rejected
If you must abort the job sequence, and you must also complete the after-job routine, try putting an Execute command activity next. I use a row count in a similar way, and the command output value det ...
Resolved
 Topic: Replace Strings in a text file
FranklinE

Replies: 14
Views: 911

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 03, 2018 12:31 pm   Subject: Replace Strings in a text file
sed -e 's/&PLID/#ec_Get_PLID_Value.$CommandOutput#/g'

Sorry, I missed this one, and UCDI has the right idea. Command output is only available in the subsequent stages in "raw" format, meaning ...
Resolved
 Topic: Replace Strings in a text file
FranklinE

Replies: 14
Views: 911

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 03, 2018 8:12 am   Subject: Replace Strings in a text file
Sandhya,

I'm just an adequate Unix guy. You have a sed issue that others here can better address. My only advice is to use a script with input parameters instead of a command line, because you can ...
Resolved
 Topic: Replace Strings in a text file
FranklinE

Replies: 14
Views: 911

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 01, 2018 11:09 am   Subject: Replace Strings in a text file
I have a job that generically sets a loop to run individual FTP sessions from a text file with a list of file names to get. It goes like this:

Exec Command -- script to determine the number of file ...
 Topic: Reading encrypted password into user variable
FranklinE

Replies: 13
Views: 602

PostForum: General   Posted: Fri Apr 27, 2018 7:55 am   Subject: Reading encrypted password into user variable
Craig,

I'm a designated access person in the financial industry. My fingerprints are on file at the SEC. I work in the most regulated industry in human history (well, arguable by some, but they are ...
 Topic: Reading encrypted password into user variable
FranklinE

Replies: 13
Views: 602

PostForum: General   Posted: Fri Apr 27, 2018 7:07 am   Subject: Reading encrypted password into user variable
Ray,

That would never fly here, having passwords (even encrypted) in a permanent file. Much too hackable.
 Topic: Reading encrypted password into user variable
FranklinE

Replies: 13
Views: 602

PostForum: General   Posted: Thu Apr 26, 2018 9:46 am   Subject: Reading encrypted password into user variable
Have you considered "dirty" logic branches in a job sequence? It means having redundant stages, their only difference being the environment variables used.

You are aiming for an efficient solution. ...
Resolved
 Topic: Transformer not compiling due to link name!
FranklinE

Replies: 2
Views: 305

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 26, 2018 9:23 am   Subject: Transformer not compiling due to link name!
In my first Cobol job, I was faced with a long If statement -- 4 pages worth when printed -- which was failing, and no clue where.

I took the printout to a conference room table, used multi-colored ...
 Topic: Reading encrypted password into user variable
FranklinE

Replies: 13
Views: 602

PostForum: General   Posted: Thu Apr 26, 2018 7:51 am   Subject: Reading encrypted password into user variable
You're not following me because I'm likely not understanding your situation. Embarassed

First likely bad assumption: you're storing the variables in the project repository as User defined environment ...
Resolved
 Topic: Replace Strings in a text file
FranklinE

Replies: 14
Views: 911

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 26, 2018 7:41 am   Subject: Replace Strings in a text file
As a second-level thinking, if you really need to set these values at runtime, a routine that builds a proc for you seems best. You would call that proc each cycle, and how you build it is up to you. ...
 

 Jump to:   



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