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 experience with this.
Good luck.
Search found 733 matches
- Wed May 23, 2018 12:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized password in Stored Procedure stage
- Replies: 12
- Views: 7037
- Wed May 23, 2018 11:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized password in Stored Procedure stage
- Replies: 12
- Views: 7037
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#? I know that in other stages, you must use #, and in other stages you must not. Usually the difference i...
- Tue May 22, 2018 7:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF Stage
- Replies: 2
- Views: 2660
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 definitely problem areas needing attention before loading the table definition. One thing about ODO: you mi...
- Tue May 15, 2018 7:43 am
- Forum: General
- Topic: Inhibiting sequence/job execution
- Replies: 3
- Views: 2825
- Fri May 04, 2018 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to generate warnings when rows rejected
- Replies: 4
- Views: 3515
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 determines the triggered link. For example, if my output file is empty, but always has a header row, if...
- Thu May 03, 2018 12:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8856
- Thu May 03, 2018 8:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8856
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 better control the processing, particularly how you pass the results back to the stage. Two best practi...
- Tue May 01, 2018 11:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8856
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 files (sets end value of loop). User Variable -- set variable values from script. Loop: Exec Command -- get...
- Fri Apr 27, 2018 7:55 am
- Forum: General
- Topic: Reading encrypted password into user variable
- Replies: 10
- Views: 9841
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 pikers, really), and I will happily stipulate that my shop is as closed-down as it is possible to be a...
- Fri Apr 27, 2018 7:07 am
- Forum: General
- Topic: Reading encrypted password into user variable
- Replies: 10
- Views: 9841
- Thu Apr 26, 2018 9:46 am
- Forum: General
- Topic: Reading encrypted password into user variable
- Replies: 10
- Views: 9841
- Thu Apr 26, 2018 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer not compiling due to link name!
- Replies: 2
- Views: 2219
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 pens to carefully chart the various Ifs, Elses and Thens, and after 3 hours was ready to break somethi...
- Thu Apr 26, 2018 7:51 am
- Forum: General
- Topic: Reading encrypted password into user variable
- Replies: 10
- Views: 9841
You're not following me because I'm likely not understanding your situation. :oops: First likely bad assumption: you're storing the variables in the project repository as User defined environment variables. If that's not true, my suggestion is not appropriate. I thought that was true when you mentio...
- Thu Apr 26, 2018 7:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8856
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. I would still avoid using DataStage, but if your architects believe it to be the best choice, have a...
- Thu Apr 26, 2018 7:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8856
I strongly caution that since this is JCL -- job code that will be executed by the operating system, not data to be processed (at this level) -- that DataStage is a bad choice for accomplishing your task. In JCL -- with a strong parallel in the job sequence -- it is best practice to break up distinc...