DSXchange

Okay, I am still trying to call a stored procedure in SQL Server.... Thanks for your example Massi, but something still doesnt work. I am trying to get the result of a stored procedure which contains an "@" in it ( execute dbo.p_GetNextId 4,1,@STRING OUTPUT;) Heres my code. Everything is fine up to ...

ASCII chars 251-254 are reserved by DataStage. Theyre part of dynamic array handling. DataStage is working with your data as an array instead of a single row. Quick question: Why do you have values in that range? Are you sourcing from Universe or Unidata legacy systems? What is the source, file or d...

When writing a string to a hash file that contains an ascii 254 we find that this character is treated as a delimiter so the string is split and the second part of the string following ascii 254 gets written to the next field of the hash file. Similar problems happen when using a UV table instead of...

Have you tried a test table with the same field type? Also, check if you are using the correct odbc drivers in your setup. Are you using NT as datastage server - if so, maybe someone with NT can help with this one. -----Original Message----- From: Rui Soares [mailto:rui.soares@novabase.pt] Sent: 31 ...

You can use a user-defined query. In this case, you would probably create indexes on the minsqft and maxsqft columns in whatever database you were using. This can even be done using tables in the project (use the UV stage in this case). However, it is not possible using a Hashed File stage, which pe...

No problem, but answer depends on the type of stage you are using. You will need to use a user defined query. Here is an example: Reference link columns: min_sf (key) max_sf sf_code Query for ODBC stage: select min_sf, max_sf, sf_code from sf_code_table where ? between min_sf and max_sf or, for ORAO...

Hi all, I have thee need to do a transformation with a range or a between lookup on a relational reference. The source feed has a square foot measurement and I want to assign a code for that square footage by looking up the data in another relational table that has a code, a square footage min and m...

Hi All! I am trying to call a stored procedure with return a value(string) in SQL Server. I am having problem getting back the value using SQLExecDirect and SQLBindCol. Is there anyone who can provide me with a DS Basic code example for calling a stored procedure which returns a value? I would appre...

Hi, we are working with DS 4.0, and now we have the follow error when we try to extracted same information from Oracle, using the stage OCI "Oracle datatype not presently supported" We are made an extraction of one field ( IDNum Char(11)) Can anybody help ? best regards Rui Soares > Rui Miguel Soare...

Hi Shawn and Lamont Now its working fine. Thanks for ur advice with thanks and regards, Binu --- lamont.lockwood@ascentialsoftware.com wrote: > Here is a small .zip file with a .dsx and four files > (two input/two output) > that demonstrates both pivoting and collapsing data > (reverse pivot). Hope ...

Binu, Look for the technical bulletin on it, it is on the install CD in the DataStage PackagesPlugin StagesDocsEnu directory. The plug in is fairly easy to use, it will take a repeating column such as sales_apr, sales_may, sales_june and put them into multiple rows of output. The key point is that o...

hi all,
Im trying to use the Pivot stage but I dont
understand how it works. some one please help me..

with rgds,
Binu

__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better http://health.yahoo.com

Does anyone know a short cut to compile all the jobs in a project ??? Cheers, Andy. ________________________________________________________________________ This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confident...

Thanks guys, I decided to use a routine instead. Regu. -----Original Message----- From: salvatore.serra@ascentialsoftware.com [mailto:salvatore.serra@ascentialsoftware.com] Sent: 30 July 2002 18:32 To: datastage-users@oliver.com Subject: RE: E-mail Notification Stage Hi guys, I have the same problem...

Was this ever resolved and, if so, what was the resolution? >From: boupha.thephavong@ingbank.com.au >Reply-To: >To: datastage-users@oliver.com >Subject: Upgrade datastage from 4.0 to 5.2 problems >Date: Fri, 21 Jun 2002 11:28:30 +1000 > > > >Weve recently upgraded from datastage version 4.0 to versi...