DSXchange

Yes, I have.

But the command insert parameter value inserts the parameter name and ds is complains about the syntax. I have tried informing the parameter name between ## but it didn't work.

Hi there,

I have some parameters defined in Sequence, but I am not getting the right syntax when passing them through to the jobs in the sequence.

Any ideas about the right syntax?

Thanks

Hi Roy, Thanks for your interest in helping me. Yes, it was working before. It's been very hard to identify the problem. I tested the informix client and it is working. Have changed the user that executes datastage as service to admin and it still doesn't work. As another test, I've written a perl s...

Hi there, I am getting this error when trying to run a job that pulls data from an informix database into a file. I am using the informix stage. This job worked before but suddenly it stopped. Any ideas on how to resolve this??? This is the entire error message: ds_loadlibrary: Win32 error in LoadLi...

Hi there,

Has anyone had any issue when migrating from datastage 7.0/7.1 to 7.5?

Thanks,

Thanks Ray.

Hi there, I am getting a warning from informix every time I run a ds job. It's not causing the job to fail but I'd like to see if anyone has ever seen this before and resolved. This is the waring : BadDebt..Informix_CLI_1: This data source does not support transactions. The job has a odbc connection...

Got it!!!

The file name in the sequential file stage should look like :

#Source_Dir#\DailyBadDebt-#DSJobStartDate#.csv

Mate,

I would like to use a macro. Could you post an example using macro?


Cheers

Hi there,

I need to export data into a file that has to have this sort of name "dailyextract_yyyymmdd". How can I do this using a job?

I know that's something to be informed in the filename in the sequential file stage but I am not sure what.

Cheers

Hi Ray,

Thanks for reply. Mate, I know that ds repository is a database but I couldn't find any information on how to pull data from it. Do you mind elaborating a bit more on it? Just tell me how setup a connection to it like odbc or something.

Cheers,

Hi there,

Has anyone ever queried the ds repository using perl? If so, can you provide an example ?

Thanks,
Melquior

Hi Deepak,

The problem is that we don't which jobs have generated such huge logs. I would to have a script the pulls the jobs and how much log data each job has.


Thanks,
Melquior

Hi,

I need to find a huge log generated by job within 1000 jobs in order to delete it. How can I do that quickly?

Thanks

bdixon wrote:Hi All,

Does anyone have an example of a bubble sort in a before subroutine?

Brad

Hi Brad,

Why do you need a bubble sort procedure? I mean, could you clarify your need a bit more?