DSXchange

Hi Greg, This sounds like a nice suggestion - our question is: How? Were not familiar with granting permissions in the UV database. Also, it appears to this limiation isnt subject to the table alone, but the entire UV Data Source - I cannot create a different table in the some database. Cheers, Dave...

Hi Regu Try the TRIM function. Heres what I have on this: Trims unwanted characters from a string. Syntax Trim (string) Trim (string,character [ ,option] ) string is a string containing unwanted characters. If string is a null value, null is returned. character specifies a character to be trimmed (o...

Ignore this please. Change is the function Ive been looking for. -----Original Message----- From: Saliah, Regu Sent: 12 August 2002 13:30 To: datastage-users@oliver.com Subject: Simple find and replace in a string. Guys, I have data coming in that contains a descriptive field. I need to look for a s...

Guys, I have data coming in that contains a descriptive field. I need to look for a string in that field and remove it if it exists. For example look for XXXX and replace it with . So This is the string XXXX will become This is the string . So far Ive had no luck searching the manual for a function....

Thanks to everyone for your suggestions. I was out of the office at the end of last week and only managed to get back to this problem today. With the help of Duleeka De Silva I have now managed to solve it. The solution was the setting for Line Termination on the Stage tab. I have reset it to DOS St...

Guys, Im running DS 5.1 on AIX and Ive been getting the above error when a hashed file is being populated. Ive checked the forum archives for this type of error and from what I could gather it can be resolved by ensuring the availability of space at the DS_MMAPPATH and setting the DS_MMAPSIZE to a s...

Hi, When a record contains a back_slash () character in a field and the record is passed on to the Informix Bulk Loader, the job aborts. Any suggestions to overcome this problem? Thanks. Nirnajan NOTICE The information contained in this electronic mail message is privileged and confidential, and is ...

UniVerse is, in many ways, a conventional database. Have you adjusted the SQL privileges? GRANT SELECT,INSERT,UPDATE,DELETE ON tablename TO PUBLIC; >From: "Baumann, David" >Reply-To: >To: "datastage-users@oliver.com" >Subject: RE: Permission on Universe Stage >Date: Fri, 9 Aug 2002 10:33:18 +0100 > ...

RE: bons dias Hi, We have a specific job, where in job control, we call another job. The job abort with an error of timeout, with the follow message "UEE.JobControl (fatal error from DSRunJob): Job control fatal error (-14) (DSRunJob) Job UEEPRE has not logged any events since #9628, and appears not...

Hi Dave, yes I know. You have, as I said, two task: (1) set things right for actions in the past. The Universe/Hash-Tables appear as files in your opperation system. You have to find them, under normal circumstances they are in a subdirectory and the meta-data are in a subdirectory D_, Sometimes you...

Hi Wolfgang, Thanks for the reply. Do you know what areas of the OS/Datastage installation need changing? We have altered the user permissions to global R-W-E on the all the files and directories that we believe are related to the Universve file in question but we still have the same issue. Cheers, ...

Hi Dave, It seems, that this is a problem with access-rights within your operationssystem. If you change for the past and set for the future this right in the right way problems wont occur any more. Please contact the responsible in your company for the operationsystem and let him/her solve your pro...

Hi, We have a few jobs using Universe stages however we appear to be getting users permission errors with them. If the person who initially created the Universe table uses a job that references that table (either populating or selcting from) everything is fine, however if someone else attempts to us...

It means that within the transformer BASIC code that is generated during job compilation, a variable within the program is being utilized prior to its being initialized. If you know the job number, you can look in RT_BPx, where x is the job number (or look in any of the RT_BPx directories for a file...

Hi all,

Anyone can tell me the meaning of "Program
"JOB.1243886265.DT.1262271389.TRANS2": Line 235, Variable previously undefined. Zero length string used."?

The job run ok and give this warning at the end.

Thanks in advance.

Nuno Pimenta