DSXchange

I did think Id covered Decimal as well. Basically, DataStage itself sees the number as a string, and does not change the contents based on metadata. You can achieve your desired result in a number of ways; I already suggested one way, using the Field() function and substrings. The Fmt() function can...

test

However you still have a line for each instance in the "global" Director window, even if each Detail log is cleared. With a large number of instances the log status view in Director could become unreadable. Kasia At 23:23 02/12/2002, you wrote: >One thing you should definately look into is the abili...

Dear RogerWang, you can Telnet on your Unix-Server. Then do the following ----------------------- DSHOME=`cat /.dshome` cd $DSHOME . ./dsenv bin/uvsh --------------------- and you are on the same place where you are with administrator. Wolfgang -----Original Message----- From: 911150@taishinbank.com...

you can get it from the DataStage Director -> Job -> Cleanup Ressources there you can get the PID and kill it directly or from the Unix Shell. You can probably also get it from a command prompt on the Unix, but I dont know. br Tom -------------------------------------------------------- Tom P. Niels...

Hi Ray, I think you replyed to the other question regarding the timestamps, or partialy. My question was regaring the decimal 12 scale 6 br Tom -------------------------------------------------------- Tom P. Nielsen Project Masterdata Reg.nr. 4853 / HH55.1.3 Nordea Bank Denmark Phone: +45 33335223 /...

dear all running environment : DataStage5.2 on Unix designer : on win2k server One of my job is locked on the datastage server. now, I can get the PID though the administrator (GUI mode). but I really dont like this mode (its difficult to read these information) so i hope getting those information i...

DataStage Engine (UniVerse) does not have a TIMESTAMP data type. This is why some of this problem is occurring. In fact, DataStage Engine (UniVerse) does not have any data types at all, which is why it is tolerant of data type mismatches. Table definition metadata, such as SQL data type, precision a...

Im sure that would work - or something similar, but that is NOT what i intend to implement in all my stages. I actually thought that the meta data in DataStage had an affect, other than for documentational purpose. Isnt DataStage suposed to used them for anything ? Atleast it knows that i cant put d...

One thing you should definately look into is the ability to set the Director logs to auto purge. Under Job/Clear Log there not only is an option to do an immediate clear of the log file but also the option to enable Auto-purge. This way, once a jobs runs successfully you can set the logs to automati...

Hi, Whenever we run multiple instances of different jobs on datastage v2, it creates a separate log for each and every instance. So when we open and see the director, we can see all the logs of all the instances that ran. To remove all the instance logs we have to clear status of the job from direct...

Thanks Ray, for your descriptive answer also thanks to Himanshu and David Barham. I just need to compare two dates to Find the earliest. Ayesha K. -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Monday, 2 December 2002 1:51 PM To: datastage-users@oliver.com Subject: RE: ...

The expression you require is: Oconv(Date(),"D-YMD[4,2,2]"):" ":Oconv(Time(),"MTS:") If this is going to be an ongoing requirement, you could create a Transform (perhaps called CurrentTimestamp) that uses that expression as its definition. Functions called date1() and date2() do not exist in DataSta...

The Date() function only returns the date, not a date/time. You need the Time() function to get the current time. Something like this should be what you are looking for... Oconv(Date(),"D-YMD[4,2,2]"):" ":OConv(Time(),"MTS") -----Original Message----- From: Karunaratne Ayesha - Sydney-MRA [mailto:AK...

you can do an ICONV against the date to get it into internal format and compare the values. Iconv(date field, "d4/") will get it into internal format -----Original Message----- From: Karunaratne Ayesha - Sydney-MRA [mailto:AKarunaratne@munichre.com] Sent: Sunday, December 01, 2002 6:43 PM To: datast...