DSXchange

I don't know if this is resolved but in Windows you have to make an entry in your services file DB2_FSACWD1 446/tcp DB2_LOCAL 50000/tcp DB2_TIPSY 446/tcp to tell which port db2 on your target server is listneing on. In my case it is iSeries and the port is 446 You also need to bind that server in th...

Create a parameter set and add a param called (whatever you want ) I use WhereClause Write you where clause as the value I use ((BIZ_CURR_REC_FLAG = 'Y' ) OR (BIZ_CURR_REC_FLAG = 'N' AND BIZ_DATE_MODIFIED >= '2005-12-31')) for one of mine. In your stage use select * from #Library#.#TableName# where ...

Create a parameter set and add a param called (whatever you want ) I use WhereClause Write you where clause as the value I use ((BIZ_CURR_REC_FLAG = 'Y' ) OR (BIZ_CURR_REC_FLAG = 'N' AND BIZ_DATE_MODIFIED >= '2005-12-31')) for one of mine. In your stage use select * from #Library#.#TableName# where ...

flag=1 tail +2 $1 | while read LINE do tag=`echo $LINE | awk -F',' '{print toupper($7)}'` chk=`echo $tag | tr "[:lower:]" "[:upper:]"` if [ $chk = "ACCEPTED" ] ; then continue; else flag=0 break fi done echo $flag return $flag the way you are using it as long as the scr...

try using return (number) in your script. examp if something is true then return 0 else return 1 end if you can use any number you want in your script to identify some action that takes place in your script. Then in DS you can make a dicision based on thouse values. currently you are receiving 1 of ...

SQLServer_Enterprise_12: When checking operator: The view adapter has a binding for the non-existent destination field "BUYER_ID".

When the job starts I get this message for every column in the insert list.

There is no view in this stage..

I exported a sequence from my development environment, I loaded it into my production environment and when I went to compile it in production The words compile in production means there is code there, other wise you would not be able to compile , correct. I am only saying thats a road to problems, e...

Just a thought, but I would only export executibles and their dependencies into production. Why would you want people to have the ability to change production code and be out of Sync with development. I see problems on the horizon!!!!!
Just food for thought!

Just a thought, but I would only export executibles and their dependencies into production. Why would you want people to have the ability to change production code and be out of Sync with development. I see problems on the horizon!!!!!
Just food for thought!

Also I know the connection to the server and table are correct because I am using truncate, and all the data dissapeared the first time I ran it.

SQLServer_Enterprise_12: When checking operator: The view adapter has a binding for the non-existent destination field "BUYER_ID".

When the job starts I get this message for every column in the insert list.

There is no view in this stage..

Version 8
Build 1.2

what is the latest build ??

The Invocation Id is in a JOB.config file (ini format ). This value is read in by a batch job which in return calls a complex routine which controls all the processing of all the jobs in the job array.
I have been using these for 8 years with out issue. pretty boiler plate.

Thanks

Thanks I never thought of something that simple. I changed all my settings to 3 Ran one set of jobs. Seems to be working >>>>>
Now for number one which really is the most important.!!
Again thanks for the spash of water...

I developed a set of ds jobs. I make those jobs multi instance because I run the same jobs for two different companies which use different parameters. I have two different config files with the parameters for each company seperate. I run the set of jobs through a batch job for the first instance 201...