DSXchange

I am reading data from oracle table, one column having number(9) , but I am importing from oracle table definition thru plug-in it is reading like decimal 9 with 0 scale . job is running fine. But I log file I got three issues. R_CDR: Column IN_CALLS_CNT floating point decimal is not fully supported...

In serever job I have ORABULK Stage. I need to convert this stage to PX Stage. So please tell me which stage his equal in PX.

ORABULK STAGE ===== PX STAGE

Hi


What is the difference b/w before & after job routines in Datastage? And when we will use those routines in datastage jobs (i.e. tell me situations when we are using them in datastage jobs and why)

thnks
venkat

I have a Orcle SQL Stored procedure with two input columns of type date data type, no output column. How do I call the stored procedure in DataStage using the STP stage? The error I am getting is not very helpful and is given below: SP_PS_M,0: Error occurred in call to ORPHCallActivePluginInitialize...

hi ArndW, my problem is something Similarly But here my case tail data is their and my onsite people said that read the data with varchar datatype. then write shell program to remove those head and tail meta data and call in the trm stage. seq_file -> tfm stage ( call shell program) seq. file is fix...

I am having one requirement regarding reading of the fixed width file with Header, Tail and data information. The file looks like ::: 90 20071001 3 91 AED EMIRATS ARABES ARS 0.84563700 1.18254000 1 AE 91 AED EMIRATS ARABES AUD 0.33151200 3.01649000 1 AE 91 AED EMIRATS ARABES BDT 18.76790000 0.053282...

I have a scenario where i am extracting data from Oracle database and manking tranformations on that data. So my first stage will be oracle enterprise stage to pull data and from there the job flows. My concern here is if i put the nullable filed of a column to 'YES' in the stage. but here i am gett...

Great one Ray, thnk you very much for the post :D .

hi
if it is function then pls help me,

toTrans.ALL_DUR is numeric type,

in server i have this function

PX_ICTHHMintoSec (TrimB (toTrans.ALL_DUR))

but i need to convert this function to px. so pls help me which function i need to uses in px.

thnks
venkat

Pls tell me what is the uses of
[code]RemoveWildChar() & RemoveUnWantedChar() in datastage. [/code]

and also tell me which function i need to use for same uses in datastage PX.

THNKS

VENKAT

my problem is input field i.e. PMMDATETIME as a timestampe datatype. i need to convert this to store date in one output column and hrs (hh) to other output column.

thnks
venkat

hi, pls give any help for converting iconv&oconv functions to px. 1) in server i have Oconv (Iconv (Txfm_input.PMMDATETIME[1,6],'D/DMY'),'D-YMD[4,2,2]') i need to convert this to px. 2) Oconv ((toTrans.CALLG_PARTY_NO),"MCN") to PX. 3) fmt() function tell me use in server jobs thnks ven...

Hi Arnie, In change capture stage, Change Keys must be same order in properties and input partitioning order also same for both the input links. and we the CCS, one property is their drop output for copy is true/false. i think in ur job it is true. bcuz of that no record is passing after the change ...

Hi Arnie, In change capture stage, Change Keys must be same order in properties and input partitioning order also same for both the input links. and we the CCS, one property is their drop output for copy is true/false. i think in ur job it is true. bcuz of that no record is passing after the change ...

Sorry ray, I forget to post my executed procedure any way it is working fine.

My problem is here any possible to call procedure in oracle ent. stage.