DSXchange

It should work, but I can't test or answer that for you. If it won't work for (simple) MSQuery then it won't work for (complex) DataStage. Have you looked in the web or the ODBC documentation to see if this is supported functionality? ArndW, i have searched on google with the error i got. It is the...

And by the way, i tried converting the same excel sheet to a .csv file but i couldn't read it either. I am thinking i don't have the necessary permissions to read from that server using datastage.

Ignore DataStage for the moment. If you can't get it to work with MSQUERY then you won't get it to work in DataStage. When i try reading data from excel using msquery i do not see any DSNs i have created. Fix this first. Did you specify a system DSN? I did specify the system DSN, but will i be able...

Try approaching it from a different angle. Try to read the excel file on a remote machine using your DSN from another tool, i.e. msquery. If it works then the error is in DataStage realm; if it doesn't work then you have an ODBC limitation (I believe that this is going to be the case). When i try r...

Hello all, i have to use excel file as a source in one of my jobs and i am doing it using ODBC. I am able to read the file when it is placed on DataStage Server but not able to read if it is on a mapped network drive. That is the file originally is on a different server and i have a copy of it on my...

:? So... not strictly chronological as I assumed where all you need is the number of days between any two status changes. Rather, for each Id you need a series of day counts between specific status changes? And when you said: "I need to calculate days for status change from 5 to 28, 5 to 27, 5...

ray.wurlod wrote:Yes.

Though I'd be curious about what a negative interval actually means, in a business sense. ...

Ray, the negative interval has to be ignored. The dates entered by the users were not right and that is why the negative number of days.

Is it possible after sorting if my data is in the following format. ID Status Date 1 28 2007-08-20 1 27 2007-08-10 1 26 2007-07-10 1 25 2007-08-20 1 11 2007-07-15 1 10 2007-07-10 1 5 2007-07-05 1 4 2007-07-17 1 2 2007-07-12 1 1 2007-07-13 Now this is after i have sorted the ID in ascending and Statu...

Hi all, my data is in the following format. Id Status Date 1 28 2007-09-24 1 5 2007-08-20 1 11 2007-09-15 1 27 2007-08-22 2 27 2007-09-22 2 5 2007-08-19 2 4 2007-08-20 2 1 2007-08-25 I need to calculate the number of days between the status changes. For example if status of Id 1 changes from 5 to 27...

I have the following data Number 123 123 123 223 223 223 333 333 Date 2007-08-01 2007-08-01 2006-06-03 2007-07-31 2007-07-31 2006-06-06 2007-08-01 2007-08-01 So there are three fields altogether with another field GRADE. I look up this Grade with a Grade value from the hashed file. For each match of...

I have three tables A,B,C coming from sql server database. Tables have the following columns TABLE A Apply ID Apply Desc Apply DOB User ID TABLE B User ID UserName TABLE C User ID City Zip I have to first map USER ID from Table A with Table B and then map Table C to get an output similar to below. O...

PNumber TDate 1100 2003-12-04 1100 2004-12-05 1200 2004-11-06 1200 2004-11-01 so for the above data, if i sort date by dsc order, and then use 'If @Inrownum=1 Then Lookup. Description Else @Null' will i get the following output. PNumber TDate Descritption 1100 2004-12-05 Description 1100 2003-12-04 ...

I used the sort stage, now how do i get the PNumber with the max date each time. The first row will have the max TDate and Pnumber, but how do i use @INROWNUM=1 for the other Pnumber values with max date. Could you please explain. Thanks Like most problems, I'm sure this has multiple solutions. Off ...

Hi all, I have two fields named PNumber and TDate coming from the source(Sql Server). The data is similar as shown below PNumber TDate 1100 2003-12-04 1100 2004-12-05 1200 2004-11-06 1200 2004-11-01 Now i need to do a lookup with another file which has a Description and Location Field. The Descripti...

Hi All,

I have 5 jobs which are already developed and i neet to put them in a sequence. I have to populate the start time of the first job in all the remaining jobs. Can someone tell me how to do it using GetDSJobInfo.

Thanks much