DSXchange

Hi,

I tested both expressions below and they are working fine. Post the error of the log.

DateToString(StringToDate(Left('20070123',8 ), "%yyyy%mm%dd"), "%yyyy-%mm-%dd")
DateToString(StringToDate(Left(in.DateInteger,8 ), "%yyyy%mm%dd"), "%yyyy-%mm-%dd")

Use the expression below when needs to begin starting from a specific value (Parallel Jobs) Initial value + (@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM -1)) @PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM -1)) => this expression return count begin with 0 then if initial value = 20: 20 + 1 = 20 20 + 2...

There isn't any disadvantage. I usually install in the structure below:

Installation : /dstage/product/
Projects : /dstage/projects/
Repository : /dstage/repository/

Attention for the permissions of the directory.

I will post the solution of my problem here, this can help somebody with the same problem.

WebSphere DataStage is a 32-bit application. If you are running in a 64-bit environment, you must ensure any database clients you use are also 32 bit.

The problem was solved installing Informix Client 32 bit.

KeyMgtGetNextValue(Arg1) =================== - Routine to generate a sequential number. This routine does not support access to a particular sequence by more than one process concurrently. - The routine argument is the name associated with the sequence. - The routine uses a file to store the next av...

Hi,

Can be used the function GetEnvironment(%envvar%) in the transformer stage.

Hi

I need abort my parallel job in Transformer Stage and send message to log.
Anybody could help me?

SF ---> Transformer ---> SF

In Transformer Stage I have stage variable varFlag = if in.field = -1 then 1 else 0
If varFlag = 1, I have to abort the job

Regards,
Luciana

Actual text of my conversion specification is: Specification: FXCRMCDPCC = substring[1,2] (FXCRMCDPCC) Specification: nowarn Thus the result is "01". I tried to use the string_from_decimal function together substring function but the job abort. Before (the result was "01.") Speci...

I don't have varchar, just char.

Source:
FILLER01 - Char(30)
FXCRMCDPCC - Decimal(2)
FILLER02 - Char(2)

Target:
FILLER01 - Char(30)
FXCRMCDPCC - Char(2)
FILLER01 - Char(2)

Change the option Allow Duplicates in Sort stage to False for remove duplications.

DataSet--------->Sort ---------->DataSet

Hi Ray

I added an extra Specification containing the single word NOWARN and the job that convert Integer to String finished with success (no warning), but the job that convert Decimal to String finished with warning.

Thank you,
Luciana

I used the transformer stage and the job finished with success, but I thought that the modify stage was more suitable. Interger(2) -> Char(2) ---------------------- Modify : FXCRMCDPCC:string[2] = FXCRMCDPCC Conversion : ok Status : Finished (see log) Log : Modify_12: When checking operator: When bi...

Hi I am trying to configure the modify stage. The job execute with success, but with warning in log: Modify_12: When checking operator: When binding output schema variable "outRec": When binding output interface field "FXCRMCDPCC" to field "FXCRMCDPCC": Implicit convers...

Hi I am trying to configure a native connection with the database Informix, but when trying to import table definitions returns Unable to initialize plug-in. dsenv file: INFORMIXDIR=/home/informix7; export INFORMIXDIR INFORMIXSERVER=u01r_rede; export INFORMIXSERVER LIBPATH=$LIBPATH:$INFORMIXDIR/lib:...

Yes, I sought, but the problems that return the code 81011 are related to the connection with DataStage GUI. I am connecting in the project for DataStage GUI.

I believe that the problem is in the installation, if it doesn't have as to repair, I will have to re-install.

Thank you