DSXchange

The source data pull has special charecters, i was wondering if there is a way we could filter that out in the DataStage job. There could be a lot of different special charecters coming in.

Thanks alot gurus

For PX you should be using the PX-specific tool, sorry but I don't recall the exact name or syntax off the top of my head. :( Thanks Chulett. It's called "Orchestrate schema definitions". I got it resolved. Thank you. It looks like a much cleaner version with out the datastage internal co...

chulett wrote:What tool are you using for importing? ...

I was trying to import using DataStage's
Import > Table Defnitions > Plug-in meta data definitions. I
even tried using ODBC table definitions too, its still the same thing.

sud wrote: c> Then the problem is with the job parameter in the job, may be delete it and redefine it or something ... recompile the job (any such illogical thing you can think of ... sometimes jobs do get corrupted).

Option C worked sud. Appreciate your help sud.

Do only a cat (the -n option will list with record numbers which you don't want). Use this: cat <path name>/<filename> and in ereplace, make sure there is no space between the single quotes. Appreciate your help sud. Its still the same thing, even after i changed it accordingly. Controller problem:...

Ok, please provide the following: 1> The contents of the file 2> The commands (exact) used in the execute command stage and while passing to the job Contents of file: "2008-07-24 00:00:01" command: cat -n <path name> <filename> passing to the job: Ereplace(Execute_Command_0.$CommandOutput...

sud wrote:Give this a try, use this derivation in the sequence when passing the parameter to the job:

Code: Select all

Ereplace(Link.$CommandOutput,@FM,'')

Still its the same error

I am trying to pass a 'Timestamp' value from a unix file after removing new line charecter, using a EXECUTE COMMAND' activity and the 'Char(Command Output)' value, which is a timestamp, is being passed to the next job, which has it's parameter type being defined as String. The job is aborting due to...

A "sequence" needs to be created in the database in order to use it, these are not associated with tables. You will need to issue a command such as: CREATE SEQUENCE MySequence INCREMENT BY 1 ST ...[/quote] Could you please send the whole message you posted, as i am not a premium member, T...

Using Surrogate kye generator stages, i was trying to generate a surrogate key with 'Database sequence' option. 1. Do you know where i need to specify 'Database sequence' <table_name>.nextval from dual sqlcode is: -2289 esql complaint: ORA-02289: sequence does not exist "Table is created under ...

I am using Surrogate key generator stage using 'Database Sequence' option. The database is in Oracle (both source and target). In surrogate key generator stage Source Type = Database sequence Source Name = #db_server#.#db_name#.#schema#.<table_name> 1. Does both Datastage server and Db server reside...

You need to be the specific one here, otherwise the answer to the "Can I?" question is just "yes". What caused your job to abort? What errors were logged? ... We were actually trying to do Inserts using Oracle Enterprise stage with write method = 'Load' and mode = Append and the...

Hi, I am using Oracle enterprise stage for loding data into an oracle table and selected write method = 'LOAD' and write mode = APPEND the job was aborting. 1. I was just wondering what would be the best practice/write method to choose for Inserts in DS 8.x 2. Can i use 'LOAD' method to do inserts (...

Hi

I was wondering if anybody could help me understand 'how to setup communication between DSengine and Oracle' and
'where i can find the .ini file in order to specify the requied info on the unix box'

Any help in this regard would be appreciated.

Thanks

Thanks Ray.[/quote]