DSXchange

Hi CP, the best performance can never be forseen in advance, mostly there is an try and error process and a time frame. You start with anything. I would say if the time frame is okay I leave it. If I need a higher Performance I have to build the next type and try it. The question now is what kind of...

use parameters

yes pivot is one answer, when you always have the same number, else a hashfile with multivalue, perhaps the multivalues generated by a routine may be an answer.

This is a often seen question, so do a search in the forum for the details of the "how-to"

make a iconv and ask the status

Alok, you have to follow three steps: Step (1): check dsenv if you have a ODBCINI=xxx; export ODBCINI where xxx is going to the file ".odbc.ini" in your dshome-directory Step (2): edit the file ".odbc.ini" in your dshome-directory and add an entrance for each of your ODBC-source....

simply add an empty line with an Unix-command in a before-job- or a before-stage-routine.

There is a lot of documention in DataBase theory about it, where you can find a whole bunch of information. It is important to know for operational systems. In a DWH environment it can be used, but doesn't fit so much the needs of mass Data processing.

Wolfgang

Before saying it is a buck you should check if the situation is the same. To be able to duplicate you should set a passive stage (Sequential, Hash, Ora ...) directly before and directly after the Agg-Stage.

If it still does work differently you should contact Ascential support.

Wolfgang

Hi Angel:

with:
dsjob -jobinfo "project" "job"
you get the infos, which you can grep out with UNIX-means.




Wolfgang Huerter
=====================
Cologne, Germany

You can fit the row to the structure by using a intermedium sequential file. First you open your seq-File read a whole line as a field, you change, what is needed and then you save it in an other seq-File and then you read this file.

Wolfgang Huerter
=====================
Cologne, Germany

read-only is read-only because it is realy read-only.

Before deleting or changing any read-only you have to change the read-only to read-write.

Wolfgang Huerter
=====================
Cologne, Germany

Yes it does.

But I suppose you want also know the HowTo.

Excel on a Windows-Server via ODBC on a Unix-Server "Save to csv" and read with seq-Stage.



Wolfgang Huerter
=====================
Cologne, Germany

Before you start a merge, do a simple read with a seq-Stage, if that works continue with merge.

Wolfgang Huerter
=====================
Cologne, Germany

Hi free flyer,

on the opertion system level you can write in your logfile with:

dsjob -log [-info | -warn] &nbsp &nbsp "text"


anything to your logfile.

Wolfgang Huerter
=====================
Cologne, Germany

Hello Oleg,

yes you can. Use the commandline-Interface with "dsjob".

You can do a lot of nice things with it.

Have a nice day


Wolfgang Huerter
=====================
Cologne, Germany