DSXchange

Hi, I cereated the below routine with the name 'GetJobStatus' $include DSINCLUDE JOBCONTROL.H JobName=Arg1 JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL) controllerList=DSGetJobInfo(JobHandle,DSJ.JOBSTATUS) ErrCode=DSDetachJob(JobHandle); Begin Case Case controllerList = 1 Ans = "Finished&quo...

I was able to connect to the sybase through ODBC, but when i try to connect to sybase through sybaseOC then i was getting a warning like Plug-in not initialized. I'd installed sybase client in the server where my Datastage server is mounted & made a entry in Dsenv file as below,even i was not ab...

Hi, I'd seen to all the posts regarding the same issues. Even though i'd set the variables as suggested in my Dsenv file,i was not able to connect to sybase using sybaseOC. My Dsenv file has entry as follows, SYBASE_ASE="ASE-15_0" export SYBASE_ASE PATH="/app/sybase/ASE-15_0/bin:/app/...

I've some 800 jobs within a category.

I want to capture the jobnames of the jobs which was aborted within this category in a file.

I know dsjobinfo will help,but how to tweek the jobinfo to get the joblist which was aborted in a particular category.

Thanks in advance.

Sainath.Srinivasan wrote:or easier still, convert the req char to newline.

Hi Sainath,

Could you please elaborate a bit.

In Transformer, use 2 output links and write first 8 chacacter is first link and rest character in second link and then use funnel stage to combine both the output. Hi Nirdesh, Thanks for ur reply. But if in the case of my input having more characteres,which has to be written in more than two lines...

Hi, I've a input file which holds a column of length 20 characters. I've to write it in the target which has the column length as 8 characters. So the first 8 characters should be written in first line of the column & the next 8 characters should be written to the nest line,..... But the values ...

Use an external file stage and in the output use an awk command to append each row to a file name called whatever value is in the first column. Hi Shane, Thanks for your response,Could you please explain a bit further. Since i'm new for using External Filter stage & also how the values can be d...

This is not an interview question. It is my requirement. I was only allowed to use Parallel jobs & Sequencers to achieve this requirement. Once again Parallel jobs & Sequencers . Its confusing me. can you please answer my questions. We can use only parallel jobs & Sequencer Jobs(not ser...

This is not an interview question. It is my requirement. I was only allowed to use Parallel jobs & Sequencers to achieve this requirement. Once again Parallel jobs & Sequencers . Its confusing me. can you please answer my questions. We can use only parallel jobs & Sequencer Jobs(not ser...

This is not an interview question.

It is my requirement.

I was only allowed to use Parallel jobs & Sequencers to achieve this requirement.

Hi, I've a requirement like of below, I'm reading a file where i've 2 columns (Column1 & Column2). If this file has 10 records,then i've to create 10 files where the name of files should be based on the values from the coulmn1 & the content of the file be the values from Column2. Example: My...

When i was doing a CDC,I was getting the following warning, CDC_: When checking operator: Defaulting "Column1" in transfer from "beforeRec" to "outputRec". Where Column1 was coming from both before & after extracts. I also sorted & partitoned the data based on t...

Hi, I've requirement like the following, I've a key field,if the value of key fileds are same for more than one record then we should check the date1 & date2 of both records,if the date1 value of the second record is one day greater than date2 of first record then both these records are merged t...

I'm creating a reject file in a job,If there are any records present in the reject file,i should send a mail to a appropriate DL. Current Approach: I was populating a new coumn with default value as '1' & populating the aggregation of the particular default column in another file & then read...