DSXchange

Hi Team, We have a situation where we are getting NULL value for date field. We are trying to set it NULL in transformer using SetNull() function. But while loading to the target we are getting error as NULL cant be inserted in database. Date Columns are nullable clomn in target. Our source and targ...

Hi All, We have a Master Sequence which internally calling a inner multiple instance sequnce and that internally calling a multiple instance parallel job. Job design is like--- Master SEQUENCE (parallel calling 9 times a multiple instance seuence)--> INNER SEQUNCE (Multiple instance)--> Basic Parall...

Thanks a lot.

Hi Team, We are strugling with restartability of the sequences. My job structure is like- There is Master Sequence which is calling the nine sequences in parallel. We have set like if all the inner sequence abort then only abort the Master sequence else continue triggering other inner sequence. We h...

UNIX scripts can be run in parallel. What we cannot guess is exactly what SQL you are using in your script and if that might have problems running in parallel. Can you specify "for read only" in Teradata SELECTs so that no update locks are taken? Actually Unix is reading from a teradata t...

Hi Team, We have a UNIX script which read data from database (Teradata) and make the entries in a table. We are calling same script in more than 100 datastage jobs and those jobs are running in parallel. Just want to know that if we run the jobs in parallel do we face any issue? If there is any issu...

Hi All,

Is there any contraint on length of Environment parameter name in datastage administrator

Hi Team,

Is there any utility in datastage 8.1 which can be integration with Job or DS routine to find out all the not compiled jobs in a project and compile it.

Hi All, We facing one data related issues while loading data from Sequential file to Database. Jobs design is like Seq File------------>Target db(Oracle) We are geting records like 1) "364237",5/31/2010 0:00:00,"PERIMETER CENTER LOFTS LLC","00001316","CRE" Abo...

Hi All,

I am getting following error while executing Datastage job--

"Incorrect dboptions option list; it failed on Expected "," or "}", got: "$", line.
A user name is required in the dboptions option."

Please suggest us.

Regards
Santosh

Hi All, I have a requirement to capture the reference data which is not matching with the master data set. How could we implement in DataStage using a single stage means either Transformer or Lokkup or Join or Merge? definitely we can use the merge stage to capture the secondary(i.e ref ) dataset b...

Hi All, I have a requirement to capture the reference data which is not matching with the master data set. How could we implement in DataStage using a single stage means either Transformer or Lokkup or Join or Merge? definitely we can use the merge stage to capture the secondary(i.e ref ) dataset b...

Hi All,

I have a requirement to capture the reference data which is not matching with the master data set.

How could we implement in DataStage using a single stage means either Transformer or Lokkup or Join or Merge?

nani0907 wrote:here is the command line prompt to get list of JObs.

dsjob -ljobs <Project NAME>

Hi,

I tried running the above mentioned commond from UNIX prompt
but getting message as

"-bash: dsjob: command not found"

Hi All,

Can we pass the Job parameter to After - job subroutine ExecSH?