DSXchange

Will you be putting in an appearance Vincent?

There is one in Server, wouldn't be surprised if the equivalent exists in PX.

Less rows out = less rows per second for the same measurement of time.

Inquisitive wrote:ORA-00054: resource busy and acquire with NOWAIT specified

The table is in use and you need to figure out why. Could be as simple as you being parked in it in TOAD... not that I've ever done that before.

Ah... I know what's going on. :D Those trigger expressions are one of the few places where a Job Parameter should not be wrapped in hash/pound signs. You can verify this by using the elipses (...) to build your expression rather than typing it in by hand. In DS BASIC, the '#' symbol is equivalent to...

My final join Job also gives me an error on validation. You really should start a new topic for this as it's unrelated to your previous problem. It's been a number of years since I've bothered to Validate anything. An 'access violation' is usually a sign of a code problem - with the Vendor, not wit...

0160 If (#Path#=D) Then GoSub L$V0S45$START "NE" unexpected, Was expecting: Array Name, Variable name, New variable name, ';', Statement label, "ABORT", "ABORTE"... Did you code a 'not equal' expression anywhere using 'NE'? If so, try using '<>' instead. You might also want to try putting quotes ar...

Something, most likely one of your Job Activity stages, has that as a parameter's Value Expression. Or it is referenced in a custom trigger. And it implies there's no such stage name in the Sequence job as 'Routine_Activity_32'.

Can you check for that?

Are you sure you exported it?

You need to explicity include 'read only' objects when doing so.

Your scripts assume a cwd Actually, it doesn't. The first step is a 'cd' to a fully pathed directory. Not sure what else might be going on, but all that looked odd to me off the bat was the exit used when the third paramater is a '1'. It should say 'then exit 0' rather than 'then exit =0' as far as...

NeelimaTalasila wrote:according to my requirement we have to use only shell scripts and datastage without routines thats the problem thats why am searching for solution other than using routine

Ok... what happened to the 'without routines' requirement?

Sure, they all use the $ORACLE_HOME specified in the dsenv file when they need to connect, but the Bulk Loader is a little different animal. It creates a 'control' file to set Schema and Table names post-connect which is probably your issue here. Check the '.ctl' file the stage generates and make su...

You might want to explain your question a little better, possilby even post an example. Which 'delimiters' are you asking about?

Please help you what, exactly? What 'integrity constraint' has your job violated? Specific examples will go a long way towards getting specific help. Unique Key constraint? Typically, you need to check inserts versus updates to avoid this problem. However, on a initial load you need to figure out wh...

Hmmm... Control-M is an Enterprise Scheduler. That means that (typically) you have one central place where all 'schedules' are kept and they can be processing commands on many different platforms and many different operating systems with many inter-dependancies, as long as there is a Control-M clien...