DSXchange

I am running a flat file into a SQL server table using a SQL server bulk load stage. In this stage there is an option to put in a bit of sql code before the job imports data. In that line I have put: delete dbo.STG_JOC_TBL where direction = 'E' After I inserted that line of code and increased the jo...

I am running a flat file into a SQL server table using a SQL server bulk load stage. In this stage there is an option to put in a bit of sql code before the job imports data. In that line I have put: delete dbo.STG_JOC_TBL where direction = 'E' After I inserted that line of code and increased the jo...

Jim What do you mean "see"? I have written to mapped drives with DataStage in UNIX. I have not tried to see them in the Designer when it asks for a filename. I woild imagine there are a couple things keeping you from using these drives or filesystems. First the drives where not enabled wh...

datastagedummy wrote:Jim It's all in the documentation for Link Collector Stage.

In my eternal need for speed i must have just passed right over that. Sorry for clutering up the forum and thanx for the help
Jim

Here is what you need to do Goto the Job Properties 1. Click on the Performance Tab 2. Un-check the "Use project defaults 3. check the "Inter Process" radio button. Re- compile your job. All the best. That worked.....Im confused as to how im supposed to know that but it worked. Thanx...

On my ds server I have maped a few drives...but when I am in designer I cant see them....any reason why? Jim I am not sure if it's the same problem as we saw with UNIX, but on UNIX, we have had problems accessing linked drives. Mapping drives follows the same concept, so you probably have the same ...

You know u go to class and you do exercises and then you go back to work and it neaver works!!!!!! Its always something stupid as well. here is what I am doing: simeple job right now taking one file running it through a link partitioner, then each feed out of the link partitioner goes through a tran...

You know u go to class and you do exercises and then you go back to work and it neaver works!!!!!! Its always something stupid as well. here is what I am doing: simeple job right now taking one file running it through a link partitioner, then each feed out of the link partitioner goes through a tran...

On my ds server I have maped a few drives...but when I am in designer I cant see them....any reason why?
Jim

On my ds server I have maped a few drives...but when I am in designer I cant see them....any reason why?
Jim

On my ds server I have maped a few drives...but when I am in designer I cant see them....any reason why?
Jim

Um...Im guessing that this proves that there are hundereds of ways to do this. Unfortunatly im not even close to being advanced enough to understand what you did. Ill share with you what I did In the after job subroutine i put in: call \\scrbbususcnc01\Maersk_DW\WQAS\BatchFiles\wqasetl.bat #DSJobSta...

JDionne wrote:worked like a charm
Thanx
Jim

If i wanted to run two dos commands after job has run do i seperate them with a ; ?
Jim

worked like a charm
Thanx
Jim

To rename a file you can use a similar synatax in an after- job subroutine, like (how was this in Windows?): ren file file_#DSJobStartDate#.txt. In Unix, I would probably use the OS to create the new filename, like: mv file file_$(date '+%Y%m%d').txt Im testing that now..Ill let you know whats happ...