DSXchange

its a Char (4) data type

it is set to 0x0 ...not sure what it must be..plz help me out

Hi, I have a char field coming from input and i am doing a lookup from DB which have a datatype of char. When i am deploying this as a serivce i am getting output as "��&#0" which are special characters. is there a way to eliminate these ? If we use varchar we wont get it...

How to convert an Interger value to Varchar and Varchar to Integer.....

Please help me...I dont know how to convert this value.

Sreenivasulu wrote:You should avoid using * in the select. Better use the column names along with the alias.

I think you can debug also faster.

Regards
Sreeni

thanks for the reply Sreeni...infact i have try that too but i guess something is missing the sql itslef.

can anyone figureout what exactly is missing in this sql

if ORCHESTRATE.usage = "ALL" and entity_at.id = ORCHESTRATE.id THEN
SELECT * FROM comm_at
ELSE
SELECT * FROM entity_at WHERE end_dt >= sysdate
and entity_at.id = ORCHESTRATE.id
end if;

Not sure what the error is

I have tried that...and i am getting the desired output to my flatfile.
Ther problem is only when i am using the option "aggregate" in the service....If i put single row it works fine....

Hi All, I am getting multiple outputs to a webservice...So inorder to handle that i am using a xmloutput stage before the wsdl output. When i am trying to test my service i am not getting the fields which i prefer. Design:- With in the xml output i checked on aggregate rows I specified a key field N...

Its a WISD Input stage... The file is not created

Please help me out....I am getting the below error and the job is getting aborted -

WISD_Input,0: Unable to initialize ipc: dspipe_init(3778): open(/ama/etl/projects/.../tmp/ade.xyz.WISD_xyz.1256572751533.WISD_Input) - No such file or directory

I was being a fool......#$variable#.......

Look like a bug in odbc stage...it pulls only $variable....

Thats true....When i am provided password field as encrypted the job gets aborted and fails...But i put as string it runs fine

Hi, I am facing a strange error.....I have a job and when i am trying to load data from Informix database through user defined parameters (DSN/USE/PASS) the job is getting aborted ....but when i am trying to run the same job using job level parameters i runs clean. Suprisingly i just added user defi...

Hi, I am using parameter sets in my job and they run fine. When i replace the I/p and O/P files with WISD I/P and O/P i am getting a problem. As a practice i create a service/operation and point the service to the job the Information server console throws a error saying "Error trying to create ...

try using DRS stage instead of entraprise stage.....i till will give the pecific errors speciffcally