DSXchange

Im not surprised that a function executed against a string that is "not null", is unable to return "null" as an answer, even though "conceptually" we might think of it that way (trimming a blank leaves "what?"). That functionality could be debated by data modelers until the sun goes down. Instead, w...

Thats right, I would like a question that Im sure could be really simple. Could you pls tell me why the following simple Transform Function reply me always NOTNULL Arg1 = " " If IsNull(Trim(Arg1)) Then Ans = "IMNULL" End Else Ans = NOTNULL End Thanks P.S. And about the NamedPipe? We have tryed to un...

Hi All, This might sound a bit strange, but I am not able to find a job that I have created. The situation arised like this. I edited a job in the designer and clicked File-->Save As to save it in a different name. There was some error message saying that it cannot save the job but it did save the j...

This is a topic for an orphaned message.

If you want to set a variable to the null value, you must use: Ans = @NULL The somewhat confusingly-named pseudo-variable @NULL.STR represents a string containing the single byte x80. That happens to be the representation of a null field when stored in a hashed file, among other things. Within DS jo...

You have a new option in 5.1 with the sequential stage. You can define just the first two fields and then mark the option on the Format tab to "Suppress row truncation warnings". Added for exactly the situation youve described. -craig "Phaneender Aedla" cc: Subject: RE: Sequential file stage 02/28/0...

Hi, You need to know the maximum possible columns that the seq file can contain. Define all these columns in the seq stage and if u scroll to the right, ull see Incomplete Column. Set it to Replace or Replace & Warn if u need the warnings. Use the transformer stage to get which ever columns u need. ...

Hi all, does anybody know something more than online help about named pipe option in sequential file stage?? Moreover does anybody tell me wy executing a routine with Ans = @NULL.STR the result is "?" (euro money simbol) simbol instead of NULL???? Thank u Bye Riccardo Tani Staff Consultant Direzione...

At 03:51 PM 2/28/02 +1100, you wrote: >Hi All > >Has any one any examples of how the OPENPATH and relevant statements >are >used on >hashed files. > >After reading the PDF files, I am none the wiser. OPENPATH /myaccount/myproject/MYHASHEDFILE TO FP ELSE PRINT "Cannot open file" END READ Rec FROM FP,...

Hi All

Has any one any examples of how the OPENPATH and relevant statements are used on hashed files.

After reading the PDF files, I am none the wiser.

Thanks

Adam

Ascential Software do not make recommendations on the table size for Aggregator stages. Clearly the only possible answer is "it depends"; what other memory-hungry things are there in the job design (for example Sort stages, Hashed File stages with memory caching enabled), how much data has to be agg...

Hi there, I would like to submit you a question. Is possible declare in the Sequential file stage a structure without define all the field on the Seq File without recive the "too many columns in row..." message?? That means: if I have a seq file with the following record Giovanni,Boccia,Italy May I ...

Dont use the aggregator stage. Use a multi-threaded tool like CoSort or SyncSort. The aggregator shouldnt be used for high volumes or complex sorts/aggregates, the best shot you have is to sort the data first and use the sorted data switches in the aggregator. Otherwise, you are single-threading you...

you can right code in your job control to extract the Job times and perform your compare. I am currently doing that for my scheduled jobs to measure duration and to inform me when jobs are running way to long. Here is the code I use. Works perfectly for me. If (Status = DSJS.RUNNING) Then Stime = DS...

Raymond, Thanks for your reply. What is the recommended table size to be used to tune performance of a job, which has Aggregator stage?. Or any other the mentioned properties could be changed to improve the performance?. Regards Saravanan "Raymond Wurlod" To: Subject: Re: Performance tuning of ETL j...