DSXchange

Hi, i am getting the the error saying [ could not connect to data source] [network error] when i am trying to upadte or upsert on any tables. the same job was working fine previously from the past few days its giving the above error The job works fine if i only insert the data to the tables.and all ...

yup thanks

actually i had set the skip count to 10 and was viewing the data but thw table contained only 2 records

thanks all

Hi All when i select the view data option the ODBC stage is giving the error no rows were returned from the view data server command ##I TOSH 000002 17:59:16(001) <main_program> orchgeneral: loaded ##I TOSH 000002 17:59:16(002) <main_program> orchsort: loaded ##I TOSH 000002 17:59:16(003) <main_prog...

My Parallel job is able to read data from DB2 in (windows2000) and giving correct results , but the only problem is reading from DB2 in (AS400). Is there any environment related to parallel job that has to be set, so that the job can read data more than 32 bit. I even tried changing the data type of...

i am using the version 7.5.1

actual value is
2474756317

when view data is performed
the value retrieved is
2147483647

and no warning is issued

i am using the ODBC stage and trying to retrieve the data that is srored in DB2 The datatye of the column is numeric(15) in datastage the server job is also using the same stage and same datatype but retrieveing the data properly but the parallel job is not able to retrieve the data which has the da...

hi All i am comming across a strange problem where where i am not able to retrieve the data properly like the data type of the field is numeric(15) and the value coming In is 2474756317 the data is getting retrieved properly for server jobs but in the parallel jobs there is inconsistency in the data...

yup
thanks all i was able to achive it by opening the stage in the grid style mode

yup
thanks all i was able to achive it by opening the stage in the grid style mode

ya thats true but it increases the number of jobs what we have to create since i have to call the procedure after the job is being executed we need to create another job for executing the stored procedure .since the odbc stage can have only either the input or the output link . is there any solution...

Hi all, i am struck up with a requirement where i have to execute a stored procedure after after the job finishes . and i am using the dynamic RDBMS stage to achieve this but i am not able to achieve it using environment variables like for (password) since it takes it in the encrypted form can anyon...

select 'What do you mean?' from dual where stage_name in ('FUNNEL','AGGREGATOR','MERGE','PIVOT') Sorry, but that's all that came to mind when I saw your post. Perhaps someone else has something more constructive, but I honestly have no idea what you are trying to find out here. There are no 'sql qu...

no i dont have the command to encode it to binary form

can u encode the above input to any format of your choice so that i get the clear idea so has what to specify in command line

pls post sql queries for following stages

1>FUNNEL

2>AGGREGATOR

3>MERGE

4>PIVOT