DSXchange

Like I was saying , I try with the transformer-stage. But I couldn't introduice the File 'B' with ready SEQ_NUMBER data in this transformer to enable populating of empty FIELD "CLIENT_TK" that I add in the File A with column "CLIENT_TK", "NUM_CLIENT", "NAME_CLIENT&...

Use a Transformer stage. On its input link use column names A, B, C that correspond with those you have defined for the sequential file (though, to be honest, the Sequential File stage does not care ... Thanks' for your response. Realy, it didn't work at the first time because it was messing one Li...

Hello, I've a problem by trying to populate SEQ_NUMBER-FIELD values in already populate file. I've in one side the file 'A' with all FIELD(client_Nr, Client_Name,etc) already populate with data. I want to add a Field-name Client_TK in this File and Populate for each 'Client_Nr' of the File, a Client...

DataStage is not resolving this to a parameter value at runtime. It's not recognizing it as a parameter. We have the same problem with Teradata API stage. We're testing a patch.[/quote]

Thank's for this information.

DataStage is not resolving this to a parameter value at runtime. It's not recognizing it as a parameter. We have the same problem with Teradata API stage. We're testing a patch.[/quote]

Thank's for this information.

Hello, I'm trying to populate database table with data comming from sequentiel file. I thing it is possible to populate the database table(DB2 not Oracle) with H,P,Q FIELD with a Sequentiel Field With A, B, C FIELD-name with sql statement like this: insert into table_name (H,P,Q) value(A,B,C). I try...

The probleme is that, after seting up environment parameters(server_name, UserId, PWD) connexion to database in administrator and calling this in DB2-Stage like this: #$server_name#, #$UserId#, #$PWD# , runing the Job failed. Failed how? I receive the followed Message Error: 'DSTAGE-DB2CLI-0005': U...

Introduce the environment variables into your job as job parameters (or in a parameter set), then use job parameter references within your DB2 Enterprise stage or DB2 API stage. ... hello, thanks for your Reply. Is there an other way to do this, differently from the way you advise it to me? Because...

Hello!!! has some one allready setting up the environment variables in the Administrator and then call the Database globales Parameters into a DB2-Stage without problem? Sequentiel file and all other stages work well with my environment variables calling in this Stage. Only DB2-stage did not work we...

There is already a new topic about my extra question.
Thank' once more for all your response. I populate the table als promise. It doesn't work too. I'll see with IBM...
Thank's for every one.

Thanks Mike and all of you for all your Suggestion. I'm not confusing the Expiration and Purpose or Purpose and derivation. I talk about this to make you realy know how I set up the step Nr 4 of the IBM tutorial about SCD-Stage. Today I've done many change in order to understand that problem, withou...

Thanks Mike and all of you for all your Suggestion. I'm not confusing the Expiration and Purpose or Purpose and derivation. I talk about this to make you realy know how I set up the step Nr 4 of the IBM tutorial about SCD-Stage. Today I've done many change in order to understand that problem, withou...

How about taking a step back and reviewing/summarizing details?: 1) Have you verified that your default date format is actually "%yyyy-%mm-%dd"? This is the installation default, but it can be changed using the Administrator client. 2) For the output column that you chose for the Expirati...

Hello All, I' have a problem by setting environment variables and than calling the connection to DB2 over this Environment variable. But, by defining the same environment variable als Job parameters, all work good. With datastage server application 7.5 i'used to call my the table in Oracle stage lik...

There are two expiration dates for a Type 2 change. Have you perhaps missed the one for the expired record? Otherwise keep trying things like double-quoting the date, for example "2999-12-12". ( ... I've allready use double-quoting and so one.. You say there are two expire date for type 2...