DSXchange

Hi Dirk, i have always found enough info in Datastage help on-line. Open the designer then click on help menu. ) Riccardo ----- Original Message ----- From: "Dirk Moolman" To: "Datastage List" Sent: Monday, October 01, 2001 3:19 PM Subject: Date conversions > Hi, where can I find more information ab...

Hi, where can I find more information about the iconv() / oconv() functions ? I looked at the Server Job Developers Guide, but it only shows examples, and doesnt explain the different codes. Im just having a hard time understanding the codes. I am getting date errors in a new job I created, and I re...

Hi Phil, on Datastage OS/390 you cant use Datastage Server Function/Routine. Phil try to "move" the input field to a stage variable defined as string; then "manipulate" this stage variable as you like better. I think it can help you. Regards, Riccardo ----- Original Message ----- From: "Phil Walker"...

Id just like to add to Kens answer that the network can be a (the?) bottleneck. Dedicated network segments with large bandwidth and isolated subnet addresses can make a world of difference (compared, for example, to participating on the office LAN).

Okay bozofoot, the reason nobody responded is because your question is like asking "In 30 seconds or less, type the meaning of life." Also, are you an Informatica plant trying to get a cheap survey that INFA can run up the flagpole saying "See, DataStage requires million dollar servers to get the sa...

The controlling job is looking at the job log to determine if the job has started. If you have a before job routine, or code in the job control area of the job that takes a while to run, then this can result in the job legitimately running but with nothing being logged. If this is the case, then I r...

You need to be aware that the job message indicates that the job is believed to be started, but there are no indications that the job actually started. I recommend SHRINKING this value, because what is happening is the job is in LA-LA-LAND, and did not respond to the job start command. I have only s...

There is an option in DS Administrator to set Inactivity Timeout. Follow these steps to set Inactivity Timeout Go to DS Administrator. Set time for Inactivity in Inactivity Timeout box. Do not timeout option can also be selected. Once this option is set any job will not get aborted even it takes lon...

This is a topic for an orphaned message.

The solution Ray gave you only works for the server component not on the mainframe. I do not think Ray read your heading 8^) Phil > > From: Paul Ko > Date: Mon, 1 Oct 2001 10:06:30 +1200 > To: "datastage-users@oliver.com" > CC: "ray.wurlod@Informix.Com" > Subject: RE: How to convert an integer date ...

Ill try again... Please take 30 seconds to return this information; Itll be very helpful to many people, Im sure. Im trying to compile some information to help in datastage server sizing... Information Im looking for is what people ar doing with what kind of hardware. Im looking for omething like: 4...

Paul, Try this: cast int_field as date I dont have access to DS 390 at the moment to test this out, but I think this will do what you want. I think you will have to make sure the data type of the target field is date (and allows nulls). I believe the target field will be set to null if the cast func...

Hello Ray, It does not work that way in OS/390. I believe it works in the server component. I tried both of your options but both of them returned me with 100008 error code - An expression is required for the statement to be valid or complete. My syntax is: Oconv(Iconv(LM117T00_SELECT_01.LM117_TERM_...

There was an error in previous "solution". Shouldve read it before clicking Send! :-~ You need to convert the "integer form" into a DataStage internal form before converting it into an external form. Oconv(Iconv(int_field,"DYMD"),"D-YMD[4,2,2]") You can also use substrings and concatenation. Syntax ...

All you need is Oconv(int_field,"DYMD") in a Transformer stage. There are no data types within DataStage; the recorded data types are user in interacting with databases. The Oconv() function has specific rules for wholly numeric date forms, of which the above solution makes use. Eight and six digits...