Search found 15603 matches

by ArndW
Tue Mar 07, 2006 2:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrade DS 7.5.1A - Error DS_AUDIT can not be written
Replies: 2
Views: 660

Does your user have sufficient UNIX permissions in the project directory? If yes, and the disk is not full, then you might have a corrupt file. If you can go into TCL and type in "ED DS_AUDIT CFF" you should enter the line editor for that record. You can exit the editor with the "QUIT" command or yo...
by ArndW
Tue Mar 07, 2006 2:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compilation error "string too large"
Replies: 13
Views: 3455

I've reached the limit in the graphical object size, I seem to recall part of the error message told you; perhaps it is 512 or 1024 bytes. If you are close, change then name of your incoming link(s) to just 1 letter, that will significantly reduce the overall string length. The best solution for lon...
by ArndW
Tue Mar 07, 2006 11:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job wouldn't run from dsjob - ran fine from Designer
Replies: 5
Views: 1142

You would probably know if there are multiple instances, since you would add a port number to your client connect strings (i.e. hostname:31540); you can see if there are multiple ones by executing "ps -ef | grep dsrpcd", each instance has one daemon. You might have a problem when using dsjob with yo...
by ArndW
Tue Mar 07, 2006 11:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job wouldn't run from dsjob - ran fine from Designer
Replies: 5
Views: 1142

Were you logged in to UNIX using the same userid as in DataStage? Also, do you have multiple server instances running on your machine?
by ArndW
Tue Mar 07, 2006 11:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: invalid derivation
Replies: 5
Views: 1359

4th line I see
NullToEmpty(Trim(oldrec.)):
by ArndW
Tue Mar 07, 2006 10:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maximum export size for a DSX
Replies: 29
Views: 6524

Can you paste lines 302915-302930 of your dsx file? Also, is this a file from before or after the project was repaired?
by ArndW
Tue Mar 07, 2006 8:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CRC32 function
Replies: 3
Views: 1451

The CRC32 is installed on the server, not the client. Were you able to view the function from another client using your own userid or another ID?
Can you know view the function from your client or is it still not visible?
by ArndW
Tue Mar 07, 2006 8:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maximum export size for a DSX
Replies: 29
Views: 6524

Colin, that looks like a parsing problem in the DSX file layout; it uses a structured format akin to what xml does, and the "BEGIN" tag was seen where no prior "END {label}" tag close off the previous object. Doesn't seem to relate to the object itself. Is this error in a split .DSX file or the comp...
by ArndW
Tue Mar 07, 2006 7:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: trim and extract specific data
Replies: 28
Views: 5815

I hadn't tested my code snippet, but just did. Remove the "+1" offset, that was my bad mental math.

When I call it using a string of "This is a long test string" and use KeyText of "long " it correctly returns the value "test". What happens when you try this?
by ArndW
Tue Mar 07, 2006 5:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in calling sub routine
Replies: 1
Views: 852

divine, It seems that you have not tried using the SEARCH facility to see the dozens of posts with exactly the same error message! There can be several causes and menas to repair this. First off, do you know what caused the system to start displaying this error? You might also take a look at this th...
by ArndW
Tue Mar 07, 2006 5:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: trim and extract specific data
Replies: 28
Views: 5815

First work on getting the routine working. What values did you give for KeyText and InString , respectively? Once you have the routine tested and working to your satisfaction, you need to replace the %KeyText% and %InString% placeholders in your job with the actual column derivations that the job sh...
by ArndW
Tue Mar 07, 2006 4:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error:Project DSS_P is not set up for Datastage use
Replies: 2
Views: 1306

holymac, most likely you disk didn't reach 99% but hit 100% while DataStage was working and you have a broken hashed file in that project; perhaps even the DS_JOBS (did you cut-and-paste the error message or type it in?). You should first do a backup of your project (in addition to your normal syste...
by ArndW
Tue Mar 07, 2006 4:25 am
Forum: Site/Forum
Topic: regarding manuals
Replies: 1
Views: 2121

All of the documentation is available on the DataStage CD. When you do a client installation the documentation PDFs are also installed onto your PC in the DataStage program directory folder "Docs", i.e. in my case it can be found in "C:\Program Files\Ascential\DataStage\Docs" and "C:\Program Files\A...
by ArndW
Tue Mar 07, 2006 3:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: trim and extract specific data
Replies: 28
Views: 5815

Phee, welcome to Charter Member status. It does make a difference not only to what sort of response you will get but also to how you see the contents of this site. I would write a routine, let's call it GetStringData(InString,KeyText) and it returns a value or an empty string if nothing is found. Yo...
by ArndW
Tue Mar 07, 2006 2:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job failing in IDOCs stage
Replies: 1
Views: 765

See my other answer to your duplicate post.