Search found 53125 matches

by ray.wurlod
Fri May 28, 2004 5:09 pm
Forum: Data Quality Best Practices
Topic: AuditStage - LO Analysis data element lenght
Replies: 4
Views: 3792

You might try hacking into the underlying database and changing the data type from Text (50) to something larger. I don't know if there's any code within Audit Stage that checks a hard coded limit of 50, however.
by ray.wurlod
Fri May 28, 2004 3:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uvregen error
Replies: 3
Views: 2072

The only documentation is in the Installation and Upgrade Guide , which is part of the manual set. Pages 3-27 and 8-2 (for version 7.0) contain the only references to these tunables. The critical one to get right is the gap between DMEMOFF and PMEMOFF, which is an upper limit on the size of the disk...
by ray.wurlod
Fri May 28, 2004 12:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: VARIABLE LENGTH VSAM FILES
Replies: 4
Views: 1504

If the lines are terminated, then it's very easy. All you have to do is to read each line as a single column, then parse it in a Transformer stage. The CFF (complex flat file) stage may also be able to help. Finally, you could pre-process the file, using DataStage BASIC (read up on the READBLK state...
by ray.wurlod
Fri May 28, 2004 12:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Environment variables and Job Parameters
Replies: 10
Views: 2591

I knew it had to be something like that.
Please convey my condolences.
by ray.wurlod
Thu May 27, 2004 4:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Environment variables and Job Parameters
Replies: 10
Views: 2591

None of that alters what I said. If you requested the evaluation copy then, yes, no payment would be involved. I presume it's all sorted out by now?
If not, contact the Editor by private message or email. It's his company that sells PM!
by ray.wurlod
Thu May 27, 2004 4:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uvregen error
Replies: 3
Views: 2072

There is an upper limit (set by the shm... kernel parameters) to the size of a shared memory segment in UNIX. In your case that seems to be 10MB. The figure of 11,829,248 is approximately 10MB. The total size of all the structures you've configured in uvconfig adds up to more than 10MB. You're going...
by ray.wurlod
Thu May 27, 2004 4:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: EBCIDIC to ASCII Conversion and low values
Replies: 1
Views: 1672

There are fewer code points in EBCDIC than in 8-bit ASCII. The first thing to do is to verify that the "low values" you're getting are, indeed, legal EBCDIC encodings. (Find a table of EBCDIC values, for example here and you will see, for example, that 008 and 009 are not code points in EBCDIC. Char...
by ray.wurlod
Thu May 27, 2004 4:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unique Id creation
Replies: 2
Views: 1292

If all you need is uniqueness, change the unique id so that it includes an identifier of the week, maybe a WEEK.TAG, maybe the date of the first day of the week. Otherwise you have an extra step in your processing; initialize a stage variable with the maximum value of the id, then add the value of t...
by ray.wurlod
Thu May 27, 2004 4:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Day of the week
Replies: 1
Views: 1161

OCONV(internaldate, "DW") returns numeric day of week (which day is day 1 depends on your locale setting). OCONV(internaldate, "DWA") returns the alphabetic name of the day of the week. OCONV(internaldate, "DWB") returns the abbreviated alphabet...
by ray.wurlod
Thu May 27, 2004 4:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Limit
Replies: 7
Views: 1985

If the hashed file already exists, and is not corrupted, you can use the resize utility to switch it to 64-bit addressing. Use the following commands at the TCL prompt or in the Administrator client command window. Use SETFILE to create a VOC pointer to the hashed file. SETFILE pathname hashedfile O...
by ray.wurlod
Wed May 26, 2004 8:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parameter problem
Replies: 17
Views: 3872

I've got one scheduled for tonight [my time] (after a change to dsenv). Will report back tomorrow. 8)
by ray.wurlod
Wed May 26, 2004 7:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parameter problem
Replies: 17
Views: 3872

Possible. His English is still better than my non-existent Portuguese!

Theoretically, you should only need to restart DataStage on UNIX when you change something in dsenv or uvconfig, provided you let dsdlockd run. Of course, DataStage is restarted for an upgrade and if ever UNIX is rebooted.
by ray.wurlod
Wed May 26, 2004 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error on CREATE.FILE command
Replies: 3
Views: 4374

Open the parent directory in Windows Explorer.
Select the directory in question.
Right-click and select Properties.
Choose the Security tab in the dialog box that opens.
Click the Permissions button to view/set the permissions.
Click the Help button to learn more. :wink:
by ray.wurlod
Wed May 26, 2004 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Environment variables and Job Parameters
Replies: 10
Views: 2591

24 hours is unusually long for these guys. They're normally pretty quick. The only thing that might delay matters is delay in clearing your payment (for example if you paid by cheque). Then again, they're near that part of the USA that's been ravaged by storms recently, so may have physical impedime...
by ray.wurlod
Wed May 26, 2004 4:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parameter problem
Replies: 17
Views: 3872

It it's clean, less than a minute (measured from the time you press Enter on the command to start DataStage).