DSXchange

Think about rsh access Also called as login/rlogin.

This will enable DataStage to invoke jobs from Primary System to secondary.

Did anyone gone thru this installation process? Recommendations and suggestions from Pro's who already installed will be appreciated. I saw one checklist on Installation Doc which I may follow and let me know, if something needs to be consodered and is a experience thats never documented anywhere. F...

First line is the Connection name and oracle10 is missing there. oracle10 is the Connection Name that you specified at your project level {uvodbc.config} Create a copy of the template and start editing it. Connection Name in the first line, Hostname, PortNumber and SID are mandatory. Get these infor...

For connecting to any database we DONT need tns entry location.

parsi_cnu wrote:

Yes to connect datastage server to any database it needs odbc entry right. where is the location of that file on the datastage server

TNS Entries are part of Oracle Client and should be a Oracle Database related. ODBC is a Clientless Drivers to connect to variety of databases You should have Oracle Client on DataStage Server to Use any Oracle Stage and cannot use Ora Stage just defining TNS Entry at ORACLE_HOME \network\ADMIN\tnsn...

I deeply think starting point for learning DataStage should be determined on what you know till today.

It depend on,
What you are & What you want.

There is no best place to learn than the one you choose.

K-

I strongly believe a Checklist of every other detail on Old Server will help in Migrating to New Server seamlessly. There are some bits and pieces that we need to ensure for migration. Few of them Datbase(s) and their Clients configuration (TNS Name/Connections etc.,) ODBC Entries File locations and...

A SQL validation proved that.

Update Table1 Set CityName=Orchastrate.CityName Where CItyID=Orchastrate.CityID

is the genrated Query.

Initially, In Target CityName is NULL and CityID has a value.

AFTER JOB RUN

SQL iss returning results...

Chicago,9342
,9342
,9442
Dallas,9343
,9343

Its a generated statement.

I mean a repeating value. in a column.

Say If run update tableA set Col1 = 'a' wher col2 = 4 will update 100 rows in SQL.

In my Job

It runs only the first occurance.

Thats the situation.

-K

You need to park a trigger file somewhere and use Execute Command Stage to read the file and determine your Steps. The higher level Design Logic maybe something like Step0: Cat FileA; If cmd_OutPut = CurrentDate() Then Goto Step2 Else Step1 Step1: Trigger Job A Step2: Exec_Cmd (`date`) to a FileA St...

While using update in Oracle EE (Upsert Mode)
(based on a Non-Key Value.)

Only updating the first occurance.

Any recommendations to avoid this situation?

-K

Congrats,

can you list your study material.

-R

See your DS Administrator for SAP guide.
It will help you how to define CPIC.

I remember something a parameter called CharsetFor65535, maybe that works...

For information on this parameter contact branded odbc providers or contact IBM they will solve.

This is a kind of charset conversation that missing in this entry

-R

Why are you using cronTab?
If you want to run a DS Job you need not know about it.
Are you running DSJob commands?
If you are running a script try googling...

Happy weekend...