DSXchange

I have checked the boxes to group into structure and to return an array.

wondering, if anything to do at the job level? Since, all the input column will be listed in the job parameter and do I need to have xml input stage to accept the data?

Hi all, I have exposed DS v8.7 job as web services, and the web service to send data xml array (wsdl) I have created parameters in the job and job is deployed as a service (all necessary things are done to deploy job as service) now, how do i reflect the wsdl with data array structure? any setting a...

ray.wurlod wrote:How many times do you propose to ask this question? ...

:D one time asking. Browsed through the forum on change captures... didn't find the proper answer

Let me know if you have any suggestions or didn't understand the question?

Hi All, :D I have a sinario in which I have to compare the after dataset with before dataset and wants the output in the following manner 1) If change code=1 or 3 (ie., record is new or update) then select the columns from after dataset and 2) if change code=0 (ie., record is same) then i want to ge...

You get this error when exactly? Doing what? ... I get the error when execting jobs through unix script & in particular while assigning values to jobs parameters. we use $ENV to get the parameter values exported in the unix shell and pass to datastage FOUND THE ISSUE: i have to use - local opti...

chulett wrote:You get this error when exactly? Doing what? ...

I get the error when executing jobs through unix script & in particular while assigning values to jobs parameters. we use $ENV to get the parameter values exported in the unix shell and pass to datastage

Hi ETLers, I have just migrated the scripts and jobs from version 7.5x to 8.1 & jobs get parameters through $ENV. I have taken care of all other setting required to run the jobs in 8.1 But, only issue i am facing is assigning values to datastage via $ENV. Is there any setting required in Admin o...

Thanks a lot Craig, I got the way

the requirement is to read and use the field value generated in previous job. lets say i have two jobs (Job A and Job B) both is same sequence, and say Job A is populating col 1 and i want to call this value into Job B. (just consider only one value populating per run) Sorry, i might be in hurry if ...

Hi all,

Calling a column value of job A in job B; both jobs are in same sequence
can this be achieved by 'User Variable Activity' stage / After job routine?

Thanks in adv

I am taking a reject from a file and the dataype of reject will be 'VarBinary'
Please let me know the ways to want convert it to 'Varchar' datatype

Tried with modify & column generator stage unsuccessfully.

Thanks in adv

Exactly, I Did that.. but.. not so easy to read, sure it is meant for another machine to read. Still Opening a job and looking the rules is easy..

I have a requirement where client is very much interested to see the rules applied in our datastag jobs.. for example transformation rules that we built. I generated job report but, that turned out to be consuming many pages and more complex to view then a actual job. after that they are keen to see...

Hi ETLlers, I am using StartLoop and EndLoop Activities to do run the job for n times but while compiling the sequence i am facing this issue "Referenced StartLoop cannot be found on input link" Let me know if you coould guess what would be the fix 8) Don't know who this JobControl will he...

Hi,

Me too facing similiar issue.. searched the forum but this only tread i see. & its the pivot stage producing this fatal message in my case.

Pivot,0: U_TRUNCATED_CHAR_FOUND encountered.