DSXchange

Hi, Four output links from transformer to four output files and four condition Then three you have fourth you want if three of any fails or all three fails....If i understand correctly then following will help Order the links Just use..... NOT(link1.condition1 and link2.condition2 and link3.conditio...

Sorry to mention about use @OUTROWNUM=1 in constarints for delete link
yes ...Just type user-Defined SQL
Make Time_ID as key in column tab ....
It will take "?"

Query placed at wrong forum Index

Hi,

Try following
Var1=INT(LEFT("YYMM",2)) ----- this will give the year

if Var1>79............................................

Thanks,
Anupam

Hi, No need of writing delete into before jobs tab... Just take two output link from transformer to target stage write user defined delete statement in one and insert into another, Order the link 1st delete followed by insert... Pass value from tansformer to delete statement as column value delete s...

We can do it in one job .... like

SourceODBC ----Input Data---> OD1--Dummy Input -->SourceODBC--Input Data-->OD2

Dummy Input = select 0 from OD1

But ......

My suggestion to go with two jobs

Thanks,
Anupam

Use field and Concatenation

Thanks,
Anupam

To be more specific: I have an update job and an insert job that each read from the same sequential file, use the same lookup hash-files, and update or insert into the same Oracle table. The only real difference is at the beginning, the insert job passes only new records to be processed while the u...

As i understand from ...Hmmm..
Use substrings or Field to extract Data from timestamp....Use OCONV and ICONV to get year and month...

Read Ascential PDF .....

Thanks,
Anupam

Hi,

Modify UtlityRunJob( ) routine use DSGetJobInfo to get the status of job if aborted then use DSJ.RUNRESET in DSRunJob else DSJ.RUNNORMAL.....


Thanks,
Anupam

Hmmm...

There is limit to display column data in view data... If your data is more than that limit it will display error data will be truncated... even if increase display length...

Thanks,
Anupam

Using hash file you can view some of metadata but no all...In hash file account name is nothing but project name.

Thanks,
Anupam

Oracle table name are case sensitive if you have created table with lower case and looking with upcase then it will display table does not exists.. Have you check option case sensitive in datastage or created table name....


Thanks,
Anupam

You can also try with Database link between db1 and db2
Try the query with Begin ... End.

I hope that will help you but i am not sure.

Thanks,
Anupam

I think better to go with 2 jobs as you dont want run main job or else you can go like : In stage variable : VarStage : If @INROWNUM=1 AND headerline=processdate THEN 1 ELSE 0 Unixfile----- Constraint :VarSatage=0 and @INROWNUM<>1 -----> Target (to process rest of row if headerline not found in proc...