DSXchange

Hello, One of our users is getting the following error once in a while and then the DS throw him out: DSDesign.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created. I assume this is a Windows problem but if anyone can suggest how...

Hi, Like Arnd said, there are too many factors to answer you. but just to make sure you fully understand transaction size: the number you put there is how many rows DS will write before doing a commit. in other words, all those rows will be written to Oracle Buffers in case it will need to Rollback....

Hi,

what is your target? Oracle, Informix, SqlServer...? are you using Plug in or ODBC?

in any case, one of the things you should check is the number of rows per transaction (I.E after how many rows the DS will send a commit request).

Good luck,
Keren

Hello,

Are you sure you remembered to set this column as not nullable on the Modify's output?

Keren

Hello, You have two options: 1. a batch file 2. a routine if you'll need to write multiple lines in the ExecSH often, I suggest write a generic routine that gets all the code as one string parameter with a delimiter between the lines. in the routine open a loop that reads and executes field by field...

Hello, I don't know clear case but I do know version Control: the important thing is that VC is part of Ds, which means you do not have to import and export all the time. Also, VC lets you move selected jobs between projects (not 1 job, whole project or 1 category at a time, like export works). It l...

Hello, You can read the value from the DB into a transformer in which you can use a StageVariable to call the UtilityRunJob routine like that: UtilityRunJob("JobName", "JobParam1=value1|Jobparam2=value2....","RowsLimit","WarningsLimit") You need to pass all of...

Hello atulghate,

you can use the before job subroutine as Roy said.
if you do not want to use Unix commands at all thoug, you can read the file as a 1 column file (a large varchar) and then by transformer and constraints to filer out only the rows you want.

yours,
Keren

Hello vgaindhar, In the Administrator there is a definition if you can "admin from director" - which means you will be able to see the jobs in "cleanup resource". Still, if you do not have the permissions to do so, you can press this button a million times and it won't do a thing...

Hi jayawant, In my last project we used the Export stage a lot. keep in mind two things: 1. you'll have to keep a matching Schema file for each file you export. 2. we learned that this stage can be pretty heavy. In order to save time, if we needed to get information from these files after being conc...

Hello...

after 10 minutes the DS.CONNECT still does not give any feedback. dince I have no group by or order by, I asume it is stuck as well....

Keren

hi again,

we run the same query through Bosonova emulator, which sits on the same client and it is working ok.

how do I run it through DS.connect?

Keren

Hi, we run here SQLs on DB2 through ODBC stage. usually it works fine, but in some cases the query gets stuck after a while. so far we got stuck trying to select from 2 tables: first query 2 columns and got stuck after 3812 and the second got 65 columns and got stuck after 300 records. we think that...