DSXchange

you can (in manager) create new category, select (ctrl+A) all jobs in old one and simple move them (using mouse) to a new category folder

Hello! I have encountered dangerous difficulties during loading data from MSSQL server to sybase IQ! Ascential (sory IBM) IQ plugin, creates flat file with data, adn loading script on hard disk and then (manualy or by Open Client) sends IQ command which runs loading script and loads flat file with d...

hi!

it Converts a string in format YYYY-MM-DD to a numeric internal date,
for example:
TAG.TO.DATE("1993-02-14")=> 9177

(see DS Server Jobs Developer guide page 20-4)

Internal date - it is number of days since 31 December 1967 (day 0)

But then, why are the tables identical and present in different rdbms? Is it some kind of extract produced from various different sources? I will give example: MSSQL database1: tableA(col1,col2...) tableB(col1,col2...) MSSQL database2: tableA(col1,col2...) tableB(col1,col2...) databases have the sa...

All he meant was that you could set up multiple ODBC sources in the configuration files and then specify the correct one for each run via a job parameter used in the DSN field.

so, it is the same solution as Arnd gave !!

table are identical in 100% because database is a part of special financial system and must be the same every time!!

I know that I can manualy change ODBC sources, but Sainath said sth. about parameters and I don't know what he had in his mind.

anyway thanks for help!

Can you not pass the Database instance, userid, and password into your job as parameters so that it will connect to the appropriate ODBC database at runtime? you have right yhat will be working:) but second option is more tempting for me :) because I don't want to add parameters to every job which ...

Hi! I'm using ODBC stage to get data from MSSQL server. On this server there are many databases with the same strtucture (i.e. for many different companies). Is there a simple way to use the same jobs to different data ODBC sources?? Is there some possibilty to change data sources in many jobs in on...

You can do this in DS by sorting the source and concatenating the desc on identical keys followed by writing into an hash file with the key as your source key. in what way you want to do concatenation?? using stagevariables as battaliou said?? nothing else (exept of stagevar) is coming into my mind!

Hi! I don't know if I entitled this post correctly but I haven't got better idea :) I have following situation: colA, colB 1 xxx 1 yyy 1 zzz 2 xxx 2 zzz 3 xxx and I want to get sth like this 1) xxx,yyy,zzz 2) xxx,zzz 3) xxx Is it possible to use one of DS stages to do this (maybe transformer) or is ...

thanks Arnd !! I like simple and concrete anwsers !!

regards

the limit defaults to "no limit", so each time you want to limit a run you would need to specify that in the director's run box.

Yes I know, but my question is: can I set limit default to i.e. 1000 (instead of "no limit" ??

is it possible??

Hi!! Is it possible to set number of rows after which stages are stoped, but I want to set it just one time, I don't want to set it every time when I run job. Also I don't want to use @OUTROWNUM in transformer stage. Is in DS sth like default value for number of rows limit (like there is for job par...

thanks I will search routines Instead of going parameters for 50 jobs why cant you use environmental variables which is a good solution for your requirement. could you be more specific - I try to show my problem more specific: I want to use in every 50 jobs 1 parameter (or maybe env variable as you ...

Hi all!

Is it possible to add 1 (the same) job parameter to many jobs (i.e 50 or more) in one time??
Or must I add it manualy many times (opening each job and add parameter)??

Regards