DSXchange

How about: DSLink3.call_date[1,4]:"-":DSLink3.call_date[5,2]:"-":DSLink3.call_date[7,2] :Space(1):DSLink3.call_time[1,2]:":":DSLink3.call_time[3,2]:":":DSLink3.call _time[5,2]:".000" You could use " " rather than Space(1) for slightly more efficiency; I wanted to thwart the line wrap in most email s...

LineCount = 0 Loop ReadSeq ... Else Exit LineCount += 1 Repeat will be the most efficient. The FileInfo() function has a key that returns the current line. FileInfo(filevariable,FINFO$CURRENTLINE) Constants for FileInfo() function key arguments are declared in the header file FILEINFO.H; add the dec...

Tony, Thanks. That works. Mark -----Original Message----- From: Tony Curcio [mailto:tonycurcio@yahoo.com] Sent: Wednesday, October 03, 2001 4:40 PM To: datastage-users@oliver.com Subject: Re: Can I perform two actions within a transformer derivation? Sounds to me like you want to perform the test in...

Sounds to me like you want to perform the test in a stage variable. Set the stage variable to a "1" if it is in the range or "0" if it is not. This stage variable is used in the if statement for the derivation where you need to modify the output field value. It is also used as the constraint for you...

All, I have a question about what actions are possible within a derivation. I am checking that an input value is within a range. If it is not within the range, I would like to perform two actions-- 1) modify the output for that field so that the error is easily identifiable in the error log, and 2) ...

thanks all, ive adapted one of the routines provided in the sdk for hash table lookups and have even managed to maintain a decent throughput -----Original Message----- From: Riccardo Tani [mailto:rtani@datamat.it] Sent: Wednesday, October 03, 2001 18:07 To: datastage-users@oliver.com Subject: Re: Is...

Hi Ian, if you are talking about "coursor look-up", you can read the hash file as UV table. In that way,for each records in the tream link, you can "scroll" all records in the reference link. Regards, Riccardo ----- Original Message ----- From: "Mason, Ian" To: Sent: Tuesday, October 02, 2001 3:37 P...

Hi Luc, try with "dsjob" utility. You can find some interesting info and option in "Server Job Developers Guide" installed with Datastage client. I think it can help you Riccardo ----- Original Message ----- From: "Huygelen, Luc" To: Sent: Tuesday, October 02, 2001 5:30 PM Subject: job statistics/ j...

Hi, Im fairly new to DataStage, but have worked with Informaticas PowerMart for a couple of years. In PowerMart, I had the ability to run the same mapping (code base) using different parameters (as defined in the session). Is there a way to do the same thing in DataStage? If so, can I run the same D...

I want to call a shell in DataStage but it didnt call the shell. So i think this is a path problem. So my question is where i can configure the path used by DataStage? And if i have two projects, may i have differents paths? Thanks, Nuno -----Original Message----- From: Nuno Pimenta [mailto:nuno.pim...

Hi all,

How do i configure differents paths for differents projects?

Thanks in advance,

Nuno

Hi Simon,

I suggest you check out the code in the SDK routine DateTimeStampToODBCWithTime - you might find that using this sort of string manipulation in a transform is faster.

Regards

- Chris Thornton

Hello, DS TimeStamp is in fact a string in the "yyyy-mm-dd hh24:mi:ss" format. You can just split and join the two strings you received, something like: DATE[1,4]:-:DATE[5,2]:-:DATE[7,2]: :TIME[1,2]:::TIME[... Check the syntax, as i do not have any DS running here to check it. Then, you can declare ...

Hello all, I am running datastage 4.1 on Windows 2000 with SQL server 2000. I have a flat file containing a date field in the format yyyymmdd and a time field in the format "hhmmss". What I want to do is take these two fields and merge them into a single datetime field in the format yyyy-mm-dd hh:mm...

Quick question about DSExecute - The following text is from the manual: Call DSExecute (ShellType, Command, Output, SystemReturnCode) ShellType (input) specifies the type of command you want to execute and is either NT or UV (for UniVerse) Question: what would shelltype be for Unix ? Dirk Moolman Da...