DSXchange

Hey Craig......Thanks .

Hi All, Existing: We have DS 7.1 on SUN OS. Proposed: 1). We have new AIX box with DS 7.5.1a on it. 2). Move all projects from DS 7.1 on SUN to DS 7.5.1a on AIX box. Anybody has experianced any issues doing this kind of upgradation, I found DS Install & upgrade guide is useful if you are upgradi...

ArndW, 1. As I said earlier I haven't developed any code. but I was looking at Oconv/Iconv and conversion codes logically. 2. In.Column[29,4]-In.Column[7,4] will give me no.of years on YEAR part of two dates. 3. 05/28/1994 - 09/28/1964 = 30 years / 4 monts If I substract on year part I would get onl...

Sorry if I am not clear, ex: 05/28/1964 00:00:00 - 05/28/2004 00:00:00 = 40 years My requirement: 1. Derive no.of years between two dates 2. Process data if no.of years between two dates are <= 30 years. I am able to do this writing SQL sub-query, but there are chances we may swith source databases ...

Craig,
I have to consider Month, Day and Year to derive no.of years between two dates.

Arnd,
I havent' really developed any code but I was looking at Oconv/Iconv and conversion codes logically.

Thanks
srimitta

Hi All, Any idea as how to find no.of years between two dates using in DS server. START_DT END_DT 09/05/1966 00:00:00 06/22/1984 00:00:00 07/24/1964 00:00:00 12/03/1972 00:00:00 05/31/2004 11:32:22 02/02/2006 08:22:10 I tried to play with Oconv / Iconv but I couldn't. Thanks srimitta

I checked with DBA, encrypted data is going into those feilds with varchar2 data types.

And varchar2 is srting data type we shouldn't have a problem :D .

Hey Thanks.
srimitta

Sorry for delay response. 1). We are validating decripted data in DS and after validation again we are encrypting and loading data. 2). We are just loading encrypted data from source. Here what I am trying to know is whether DS Oracle plug-in's allow encrypted data into Number and Decimal data type ...

Hi All,

Anybody have any idea whether we can use DS 7.5.1a Oracle plug-in's to load encrypted data into Oracle 10G r2 database tables.

we are looking at field level encryption (feild data types are of Numeric and decimal).

Thanks
srimitta

Can you forward (Paste) some sample records?

You are trying to read data with less no.of columns in FF stage column grid.

Means: No.of columns in file are not matching No.of columns in FFstage column grid.

Hi Guys, I have a job which loads Seq File (file.txt) and this Seq File (file.txt) is used by many jobs and I have no track of what all the dataStage jobs using this file (file.txt). Any one any idea to find out what all the dataStage jobs using this file (file.txt), other than manually keeping trac...

All services are runing fine 1). DataStage and DSRPC services are up & running and are Automatic. 2). netstat -a | grep 31538 TCP FSS06:31538 FSS06:0 LISTENING DS client componenets are sitting on Win-XP Pro. I could find ArndW's posting. I've seen some 'funnies' on ibm's machines when they get ...

I am getting this error if logon using Username / Pwd.

I am able to logon if I check Omit box to logon using NT credentials, and also I am fine logging onto DS server using Telnet services.

any idea, meanwhile I will try searching for similar posts.

Srimitta

Hi All,

I am enclountring error while connectiong to server, any idea where I need look into!.

Failed to connect to host: FSS06, project: slaes_dev
(The connection was refused or the RPC daemon is not running (81016))

Thanks
Srimitta