DSXchange

Hi, We are trying to process two sequential file by using Merge stage in DS. Pure Inner Join has been used as join type and compilation was successful. But runtime, it gives warning message as Construct_hash_table failed and job got aborted. First File size - 23 MB Second file size - 108 MB Could it...

People, Please DO NOT post file attachments to the list. Thank you. Regards, Clif Monday, October 01, 2001, 7:20:43 PM, Ray Wurlod wrote: > DataStage is having a problem saving your routine called FidelStrNull. > Check permissions on the server. Also check whether there are any NLS > mapping errors ...

DataStage is having a problem saving your routine called FidelStrNull. Check permissions on the server. Also check whether there are any NLS mapping errors occurring - you may need to enable server side tracing to determine this.

Theres not enough information in the error messages. You need to use the Debugger or a stage trace on the stage where the Trim() function is failing, and capture the value before and after. Then send the trace file (just the section for a row that fails will suffice) to support, who should be able t...

Dan, youre going to have to be more specific. Reimporting to the same project should never present a problem, unless: 1. Permissions on a unix server has screwed you up. If you guys dont have sticky bits set on project directories, youre in different user groups and the directory permissions arent p...

Hi Dan. If you have a few moments, check out the site www.tools4datastage.com . The folks there have built a Version Control product for DataStage whose most significant benefit is the deployment of entire "sets" of DataStage application "pieces" amongst DS Servers. Ascential supported this partners...

Can anyone point us to some white papers, best practices or even DS documentation we may have missed that describes the best way to "port" a project with the least aggravation. We probably did something wrong, but we were surprised that even an export and then import back to the original project fol...

This is a topic for an orphaned message.

The main problem is with the concatenation operator. For the OS/390 version you have to use the double pipe || for concatenating strings. In the solution, Id recommend creating a stage variable where youve done the conversion from integer to character. Stage Variable: Name: CharDate, Char with a pre...

Thanks, this is also what the manual said (the syntax you printed below). The "conversion codes" had me baffled for a while. There are lots of examples, but the arent really explained. I think Ive got it now. I studied the examples and tried a couple of my own formats that werent in the examples, an...

Thanks Riccardo ! I keep forgetting about the online help. Regards Dirk -----Original Message----- From: Riccardo Tani [mailto:rtani@datamat.it] Sent: Monday, October 01, 2001 3:35 PM To: datastage-users@oliver.com Subject: Re: Date conversions Hi Dirk, i have always found enough info in Datastage h...

Yes, thanks Ken. I apologise if Im not using your libraries right now. Im just taking **baby steps** first. Everything is new to me right now. I also wrote a routine today for calculating values off a string. For me it was quite cool, just getting it to work, but for you it will be a very simple fun...

Dirk, check under your start button --> Ardent DataStage --> Online Manuals --> Universe Documentation.... Ive offered before to send you a copy of my libraries, in which is a bunch of functions to recognize and conform date formats. Make sure you always turn your dates into the ISO form ---> YYYY-M...

Hi all, id like to understand Load Pack functionality better. I know that i can schedule a job from BW scheduler interface which loads data using Load Pack plug-in. But i would like to know if i can run a JobControl that executes an ETL process that ends with a BW loading throught Load Pack. Does an...

Try opening help in your designer. Then, go to index and lookup Oconv. Within this help you can hot key to what the codes mean. Syntax Oconv(expression, conversion [@VM conversion] ...) expression is a string stored in internal format that you want to convert to an output format. If expression is a ...