DSXchange

Thank you. I will check with IBM to see if we can get a patch. We are on 8.5 version. If we get a SF pack on DataStage does that solve this issue? Even with SF pack do we need to import the WSDL same way? Another question I have is we need to load SF with almost 10K records with almost 80 columns an...

Hi, I received a WSDL file from SalesForce vendor and I am trying to import this file from DataStage Designer, when I do this the designer freezes itself and need to close it. have anyone experienced this? Also are there any limitations on number of columns we can pass? Appreciate any insights. Thanks

Got it,
The issue with the password containing "&" symbol within it. Unix treats this as a command. So we requested our DBA team to change the password and everything works fine now.

Have a great day!
Thanks
Bhargava

Hi,
I am trying to connect to SQL Server. I am getting the following error when I run the job.

Unrecognized argument: &

But if I view data, all the arguments are working fine. I am using ODBC stage for Database connection.

I appreciate any idea.

Have a great day!
Thanks
Bhargava

Thanks Anbu,
I believe the prefix number for Octal is 0(zero). Let me know if I am wrong.

Thanks
Kavuri

Hi, In my source file I am getting some windows characters like vt,CR etc.. So, I am using convert function to remove them. Here below is the code I have in place. Convert(Char(15),' ',Convert(Char(13),' ',Input.Field1)) Now my question is 13,15, I am using as the octal values of vt and CR. Do I nee...

Hi, There is a huge SQL which i need to convert this into a DataStage job. Here below is the code. I may not able to give the exact code because of privacy limitations with the client. But I had converted the code as is. SELECT B.col1, B.col2, B.col3, B.col4, B.col5 FROM (SELECT e.* FROM tablee e ,(...

I wanted to see this piece alone...

Hi, I am working to implement a SQL scenario in datastage. select a.fld1,fld2,fld3 from TableA a where not exists (select b.fld1,fld2,fld3 from TableB b where b.fld1=a.fld1 and b.fld2=a.fld2 ) and a.fld2 in (select fld2 from TableB) My tables are some what huge (A table is about 50million records an...

Thanks to both of you.

Hi, I had used the work around logic to solve this. If you have any better logic or simple logic to do this let me know. month1=lnk_odbc_SQLServer.CREATE_DATE['/',1,1] day1=lnk_odbc_SQLServer.CREATE_DATE['/',2,1] year1=lnk_odbc_SQLServer.CREATE_DATE['/',3,1] month=If Len(month1) = 1 then 0:month1 el...

Hi, I have a job which is reading date as varchar(10). I am trying to convert this into date field by using the following command. StringToDate(inColumn,"%mm/%dd/%yyyy") My input data is in the folowing format 1/1/2010 here below is my error. Fatal Error: Invalid Julian day [date/date.C:10...

Hi Ray,
We dont have oracle. Oracle is maintained by a third party. We just pull the data from their DB.

Any solution is greatly appreciated.

Thanks
Bhargava

Hi Srinivas, I dont have an option to use Oracle EE stage. We need to buy oracle native drivers. So this is not an option for me. Thanks for your response. Hi Chulett, I am selecting the char and varchar fields, there is no where clause. I think my source system is maintaining some numeric data or d...

Hi, I am trying to read data from a oracle DB. I am using dataDirect for ODBC. All my other jobs are running fine except one job. I am getting the following error sometimes. [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01426: numeric overflow [odbcUtils.C:302] Sometimes the job runs fin...