DSXchange

You need to determine if you have run out of virtual memory when youve gotten the abnormal terminations. The easiest way to see this is to watch top for the swap free value going down to near zero. If your job designs are using large hash files, with read or write caches, you use up memory. If the f...

This is a topic for an orphaned message.

Hello I too have unexplained job aborts lately off and on. Once I either reset or recompile the job it will run fine. There is never enough about the error either. I have even checked the &PH& log and nothing more there helps. I have been working with Datastage support and they believe the project t...

> I have to redefine a job, but i find same logical operaters that i
> dont know If NumToNull0(Input.Tax) <=10 Then what do the "<=10"
> ? the field "lt" is not definned.

"<" is the HTML code for "

I have to redefine a job, but i find same logical operaters that i dont know

If NumToNull0(Input.Tax) <=10 Then

what do the "<=10" ? the field "lt" is not definned.


Regards
Rui Soares

You need to structure your logic differently. Setup your loop to process until the condition Done is TRUE. If you exhaust the number of lines in your file Done will be set to TRUE. If you encounter a condition in your loop where you wish to set Done to TRUE, this logic works the same. This is a very...

Hi, Could I put more than one condition in the "While" in this loop statement? I want the program exit the loop (with a warn message) if Left(Ligne,1) = < in the ptfile. That is, if readseq begun at the A label, the program have to exit (stop seq reading) when he encounter the B label, and if it beg...

This is a topic for an orphaned message.

I would like a list of all the Ascential tools and/or executables that should not be used in a production environment. thanks, Doug -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Friday, September 14, 2001 1:43 AM To: datastage-users@oliver.com Subject: RE: using ...

Thanks a lot! Both kinds of solution work fine! Alessio ----- Original Message ----- From: To: Sent: Friday, September 14, 2001 11:09 AM Subject: RE: Date conversion > Strictly, you dont need that last , the following should be enough > since only 2 separators need to be defined (or undefined in thi...

Strictly, you dont need that last , the following should be enough since only 2 separators need to be defined (or undefined in this case!), between Y & M and between M & D:- Ans = Oconv(@DATE, "DYMD[4,2,2") > -----Original Message----- > From: chris.thornton@ascentialsoftware.com > [mailto:chris.tho...

How about: Ans = Oconv(@DATE, "DYMD[4,2,2]") Regards - Chris Thornton -----Original Message----- From: Alessio Giordani [mailto:alessio.giordani@inwind.it] Sent: 14 September 2001 08:59 To: datastage-users@oliver.com Subject: Date conversion Hi all, I have to convert internal date (@DATE) in YYYYMMD...

Ans = Oconv(@DATE, "DYMD[4,2,2]":@VM:"MCN") The expression editor may object to @VM as not a valid system variable. However, it is, and will compile successfully. If you dont like the red colour, edit the DSParams file on the server (in your project directory) to include @VM in the [System Variables...

Hi all, I have to convert internal date (@DATE) in YYYYMMDD. I tried Oconv function in this way: Ans = Oconv(@DATE, "DYMD[4,2,2]") but the deault separation character (blank) betwen year month and day, produce the following result: YYYY MM DD My rough solution was to replace blanks with "" Ans = Ere...

My four main reasons to prefer job control routines over dsjob. 1. dsjob is a SAMPLE program. It is supplied as an example of how to use the DataStage C API. In places (places it seems Wolfgang doesnt use) its a bit flaky. For example (in 4.0) the -wait option fails to wait. This is not good if you ...