DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 684 matches
Author Message
 Topic: Is there a way to restart a job from point of failure?
FranklinE

Replies: 7
Views: 165

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 15, 2018 8:52 am   Subject: Is there a way to restart a job from point of failure?
High-level error handling design is where restartability is identified. Error handling is a part of the definition of the unit of work.

Example:

1. Download file. If that fails, fix problem and ...
Workaround Reported
 Topic: Create HIGH HEX value
FranklinE

Replies: 9
Views: 248

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 06, 2018 6:53 am   Subject: Create HIGH HEX value
You have to juggle the settings. Sometimes the two character sets, ASCII and EBCDIC, have implied conversions between them that you can't control.

If it were my job -- and that means you might not ...
Workaround Reported
 Topic: Create HIGH HEX value
FranklinE

Replies: 9
Views: 248

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 06, 2018 6:17 am   Subject: Create HIGH HEX value
The only thing I can think of is that you are setting the char column under the control of an ASCII character set. That's why it's getting converted to xA7 or x40.

Check your project defaults. You ...
Workaround Reported
 Topic: Create HIGH HEX value
FranklinE

Replies: 9
Views: 248

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 03, 2018 1:06 pm   Subject: Create HIGH HEX value
EDIT: Just to be clear, be careful in your description. You are not creating a string of 30 F characters, you are filling each byte with xFF.

You will have to experiment a bit, but you should be ab ...
 Topic: FTP Enterprise stage to read Mainframe variable blk dataset
FranklinE

Replies: 4
Views: 176

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 01, 2018 10:50 am   Subject: FTP Enterprise stage to read Mainframe variable blk dataset
We use a generic FTP Enterprise stage and job for all mainframe datasets. It has a single column definition of binary with unspecified length. Since the datasets have no delimiters, this creates a fil ...
 Topic: FTP Enterprise stage to read Mainframe variable blk dataset
FranklinE

Replies: 4
Views: 176

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 01, 2018 10:42 am   Subject: FTP Enterprise stage to read Mainframe variable blk dataset
CFF is very good with all of the COBOL formats, with some exceptions outlined in the FAQs. Binary (COMP) fields can have endian issues, for example.

The prefix field showing the record length is th ...
 Topic: FTP Enterprise stage to read Mainframe variable blk dataset
FranklinE

Replies: 4
Views: 176

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 31, 2018 1:17 pm   Subject: FTP Enterprise stage to read Mainframe variable blk dataset
The use of variable length fields is the first problem. In the COBOL formatting, the binary record length "prefix" is explicitly defined as its own field, but I don't see a similar "prefix" for SEGMEN ...
 Topic: Passing SQL through a string parameter
FranklinE

Replies: 15
Views: 468

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 31, 2018 12:11 pm   Subject: Passing SQL through a string parameter
Late to this thread, not sure if this will help, but we successfully use the following in an ODBC Connector stage to select from MSSql:

CALLS.local_start_time >= {ts '#CALL_START_DATE_1# 00 ...
 Topic: Run and complete a DataStage Job based on a value in a table
FranklinE

Replies: 13
Views: 832

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

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

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

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

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

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

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

 Jump to:   



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