DSXchange

Hi,

Sorry for the late response.

What exactly are you using to "see" the output?

Telnet session using cat command

Where are you storing your output?

---Sequential File output in unixbox

What is the Data type?

--Tried using Varchar,char and Raw as well

When i change constraint value as linkname.columname="039" string it works. But,am keen on why there is a octal conversion happening in between when the constraint was given as integer value. I have checked octal values which does not exist for 008,009,018,019,028,029,038,039, etc... (numb...

Hi, Am trying to compile a job with constraint as linkname.columname=039 in transformer. 1) inputcol datatype is smallint 2) checking the constraint alone in tranformer 3) same column goes as output On compiling i got the following error in transformer stage. 1540-0849 (S) The octal literal "03...

Hi,

When I tried to validate the date format of YYYY-MM-DD through IsValid function I can see only two values that can be passed to IsValid function.

IsValid(%typestring%,%valuestring%)

If I give the date format as third value to the IsValid function it throws basic syntax error.

cp `ls -ltr #$DirPath1 | grep ^- | tail -1 | awk '{print $9}'` #$dirPath2#/

$DirPath1 is missing the right # symbol.

Hi Meena,

Please check whether the parameter given in the job, does exist in the parameter list

Cheers,
Prem

Hi Everyone, I was struggling with an error which states that TGT_CL_FNC_MKT_IMT_TP: When checking operator: When binding output schema variable "outRec": When binding output interface field "CL_CODE" to field "CL_CODE": Implicit conversion; from source type "strin...

Hi Everyone, Am using oracle 10g as the database.Trying to load a sequential file data as a table into the oracle database.When I tried to load the data it shows me the following error. Error loading "orchoracle": Could not load "orchoracle": The specified module could not be fou...

The dataset 2 is the problem.

This is my actual job design.

Hi All, The job design is as follows dataset | | | dataset------->lookup------>dataset(target) (I dont know to put the diagram exactly, dataset is looked up with another dataset) In the column definition on the target dataset there is a column named "AR_PRIM_PYMT_TP_DT".The rows ran fine.B...

Thanks for the reply.

But am not a premier member.Please let me know the answer in visible format.

Ray,

Am facing the same warning in lookup stage.I dont know how to configure the lookup stage as you have mentioned to configure it.Pls help me to resolve the problem of allowing duplicates in the lookup stage
regards,
prem

Hi everybody, Am running the sequence which contains a job "Load_update_ip_delete".The sequence aborts on this job.On seeing into "Load_update_ip_delete" log,it shows the job status as running.But it seems to be struck in between.The logs of this jobs run upto "main_program:...

Hai everybody,


am working with datastage 7x server edition. win XP.
Is it necessary for the parameters to have default value in the job parameters dialog box.