DSXchange

Thanks Arnd This is where I think I went wrong earlier on today when my Job Sequence wouldn't die. My Job Sequence was running (called job_seq1) and I tried to do a DSAttachJob("job_seq1"). Obviously that was wrong as discussed earlier. Should the Job Name in the DSAttachJob be the underly...

Cheers guys - the problem has now been resolved States side. I'm fairly lucky that this happened when the States had woken up - the 5 hour difference is not ideal !!! Unfortunately, I don't have access to Cleanup Resources or the dstage command line but as ever I have learned new things through this...

I have a Job Sequence that won't stop in Director. I have a number of server job activities linked together with a routine in between each one. The routine is trying to count the number of rows that are passed between links. Where I think I have gone wrong is that I pasted in some code from this for...

Seems that I have achieved by what I want to do by doing the following :- Command = "ls -1rt *.dat" * Capture a list of file names (note option "1" in ls command, so that * output contains ONLY a list of file names, one per line). Call DSExecute("UNIX", Command, Output,...

I'm looking to do something similar to the code that Ray has posted above but rather than listing multiple filenames I want to read in one file and return a list of all entries in that file in the final return clause. I then want to use this list in a StartLoop (#Routine_Activity_37.$ReturnValue#) t...

The scenario that I have is as follows: I have a table on a MSSQL Server that contains the following information: ServerName Job Name Processing BKP_ANY2 Ptfo_Extract N ST_PPSA Ptfo_Extract N BKP_ANY4 Ptfo_Extract N .. .. .. Up to 10 servers The ServerName column is the name of a Sybase server. I ha...

thanks Roy - spot on.

I was meaning Basic when I said Job Control.

I have a number of Server Jobs that are controlled through one other Server Job via JCL. The part that I am struggling with is described as follows: I have a table on a MSSQL Server that contains basic Fund information and the location of which SYBASE server the Fund data is resident on. e.g. SYBASE...

Thanks Ray - I currently have a job sequence and a Server Job with JCL that do this.
I was just trying to have less components to manage as this sort of scenario will occur many times in the project that I am working on.

No need for further detail Roy - I just wondered if I was missing something simple. I'll live with the extra number of server jobs.
Thanks for the quick answer.

Cheers guys, I replaced the SYBASE_OC with SYBASE_BCP_Load and it did improve performance considerably. The only packet size that I was allowed to use was 512. There doesn't appear to be a function on the SYBASE_BCP_Load to clear down the table first so I guess I'll have to add in another stage to d...

I have a sequential file which consists of 595 rows and am loading it into a table on Sybase. SEQ_FILE --> SYBASE_OC The file consists of 3 columns - numeric(9), varchar(128), char(12) and matches the definition of the table on Sybase that it is being loaded into. The operation clears the table on S...

thanks Roy - I've now resolved the problem. The file that I was trying to load into the Sybase table had quote's around the char fields. Removing these has sorted the problem.

Thanks for the help - pointing me towards Director certainly helped - lesson learned

Sorry I haven't replied - got called away and then straight into the Easter holidays. I am using Sybase 12.5 - resident on Windows 2000 servers. The DataStage server is on UNIX with the clients on Windows XP. The flow of the job is SYBASE_OC -> SEQ File -> Transform -> SEQ File -> Transform -> SEQ F...

What is the best way to load a sequential file into an existing table on Sybase. The sequential file was created from the output of a transformer stage and looks as I would expect it to. I have tried the following and can't get any of them to work :- joining a SEQ File -> SYBASE_OC joining a Hashed ...