DSXchange

You do a similar convert for the time. Oconv (Time(),"MTS") will give you the time in the 00:00:00 format. Then just concatinate the values together Oconv (date field):" ":Oconv( time field) good luck himanshu -----Original Message----- From: Karunaratne Ayesha - Sydney-MRA [mailto:AKarunaratne@muni...

Hi, I am new to data stage and need to do the following.. Can someone help please a) Need to format the date in YYYY/MM/DD HH:MM:SS format.. (i.e.. 24 hour clock) I tried to use OCONV it was ok for the date part but did not accept the time potion. usage of OCONV (date(), D4/YMD[4,2,2] fine.. when I ...

My guess is that (with NLS disabled) the difference between CRC32 and Compare() would be negligible. With NLS enabled, its possible that CRC32 may be faster, as it would not need to inspect each byte to determine whether its a leading or trailing byte in a character. As far as I know theres no way t...

Hi, I have a question regarding the CRC32 function My input row is 45fields long (totally 450 long) Currently looking for changes by concatenating them all and then doing a compare - but would a CRC32( [fully concatenated string] ) be better ? (faster) i.e. inrow.field1 : @FMT : inrow.field2 : @FMT ...

HI, Yes we can get the log information with command dsgetloginfo, but this way we only have this information in the end of the job, and we need to have a real-time monitoring in Control-M We need to find a way to send the log information in Control-M, during the execution of Datastage job Regards Ru...

The system function you need is Date(). The system variable @DATE is set when the job starts and does not change thereafter. Date() returns the system date, in DataStage internal format. Use Oconv() to convert it to whatever form you require. ----- Original Message ----- From: Karunaratne Ayesha - S...

One method would be to use OCONV(DATE(), "D4-YMD[4,2,2]") ..returns the date in format YYYY-MM-DD Thanks, Bibhu Rewards Data Team 503 220 3891 (PDX) Karunaratne Ayesha - To: datastage-users@oliver.com Sydney-MRA cc: 11/28/2002 10:10 PM Please respond to datastage-users Hi, Is there a system function...

Hi,
Is there a system function to obtain the current date.. I used @Date
the value doesnt seems to be right..
Can someone help please

Ayesha K.

Hi Ray, I changed the metadata definition as suggested. However the view in datastage viewer is the same as before. Cheers Ayesha K. -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Friday, 29 November 2002 4:34 PM To: datastage-users@oliver.com Subject: Re: excel spread ...

Modify the table definition you are using so that every column is defined to be VarChar(255). Set the display width to anything you like; this affects the width of the column in the DataStage data viewer. Once everything is VarChar, there are no characters that cannot be viewed. ----- Original Messa...

Hi, I am trying to load a oracle table using a Excel spread sheet. I access the spread sheet using a ODBC link. In one column some of the data is not imported .. a) why? b) How to rectify this problem Can someone help ASAP... sample source data Excel Column Shown in Data Stage view 85 85.0 90 90.0 0...

Unfortunately (to the best of my knowledge) you cant. Most people who use schedulers identify first log id and last and send this to their reporting tool at finish. You could use a while loop and do it on interval but what would you gain?(besides creating overhead) You could read the log file as it ...

You could try "echo" without redirecting to a file. The output should then be directed to screen and be visible in the output from your scheduling software. Chris. www.altis.com.au Quoting Rui Soares : > Hi, > > Yes, but i want to get this information during the execution, during > the > monitorizat...

Try the following, where X is the input value. Field(X,".",1,1)[5]:".":Fmt(Field(X,".",2,1)[1,6],"L%6") Field(X,".",1,1) returns whatever precedes the ".". The [5] returns the rightmost five characters. Field(X,".",2,1) returns the 2nd "." delimited field. [1,6] returns the first six characters. Fmt...

use dsgetloginfo and echo or cat to a file. Rui Soares wrote: >Hi, > >Hi > > > >There is anybody who use Control-M to scheduler the Datastage jobs? > >We would like to pass same information about the DataStage job, (such as >number of rows/second, error, etc) to the Control-M. How can we do this? > ...