DSXchange

Was going to use this to detect records in a file. Converted the file into a reject, triggered a notification stage to send the file, used a sequencer with ANY option to continue process.

Attempting to set up a user with capability to start a DS job from a PC that does not have the DataStage client installed. Copied DSJOB.exe, dsclnt32.dll, and dsrpc32.dll to the PC but message received is 'Access is denied'.
Is this because the user is not defined to the project on the DS server?

The .bat file does execute successfully from DOS prompt, removing the spaces did not change the result. Thanks!

Any reason this line would work in a .bat file executed from Windows Explorer but fails when executing the .bat file from the Execute Command stage?

IF %length% == 0 GOTO NOMSG

DataStage Event Detail:
Reply=255
Output from command ====>
GOTO was unexpected at this time.

Thanks!

Thank you Ernie! I have attempted to implement the steps that you described in your response to my post but haven't been able to get information that I need to complete the subsequent calls. Here is what I see in the http response when I monitor the traffic and what I had hoped to see in my output c...

I am trying to consume some external web services using DS 7.5.2 and have the WS and XML packs installed. I am struggling with satisfying the cookie requirements of the web service provider. They are similar to many hosted services providers that return a session identifier during the first service ...

Solution Start Loop -> Exec Cmd -> UserVar -> Process -> Nested Cond -> Exec Cmd -> End Loop Exec Cmd creates a list of the .xml files in the directory UserVar gets the first file from the list - if no file found uses a dummy file Process either processes the xml or SLEEPS if the dummy file is passe...

Thank you for replies. If I go the Wait For File route my sequence would look something like: startloop -> waitforfile -> movefiles -> processfiles -> deletefiles - Repeat I could set up the iterations larger than the expected number of files for a day, start the job before users start processing, a...

I have a requirement to load information from XML files into a database. The XML files will be generated throughout the day and about 500 files will need to be processed. This process needs to be "real time", as the XML files are created, users anticipate the data will be available on the ...

I don't know what you mean by pre-evaluated into a string.

How would I pre-evaluate 0:Char(253):"'A1000P'7N":Char(253):"'U20'9N" into a string to pass as the argument?

Thanks.

Sample of Business Masks input nnnnnnnnnnC UAFAnnnnnnnnn UBFEMnnnnnnnn A1010nnnnnnnn A1000Pnnnnnnn 00040lnnnnG UAFGRPnnnnnn-nnnnnnnnn A10023nnnnnnn nnaaaaaaaaD A111109DED0NE Routine to convert vBusMask = Trim(Arg1," ","T") vSub = 1 vNodeType1 =' ' vNode1 = '' vNodeType2 =' ' vNod...

ODBC --> Transformer --> SeqFile

In the Derivation for Stage Variable svNoMatchFound, inLink.Folder_ID Matches jprFormatMasks
Constraint for the output is svNoMatchFound = 1

What about loading the Patterns to a hashed file with a dummy key. Then using a Universe Stage and Multi-row lookup with Stage Variables to exit when a match is found? That way the evaluation would occur pattern by pattern.

10M rows, 200 patterns. A performance problem in the making?

Tried @FM and @VM.

@FM doesn't work at all. @VM works only when hardcoded, not passed.

Tried loading the sv directly from the hashed file. Same result.

Looking for a new direction.

Thanks.

For clarifaction... 1. The job that was working was a proof of concept effort that had the masks hard coded in the transformer. Only when attempting to pass the masks into the job using a parameter did I run into problems. Passing the masks into the program has never worked. 2. The reason for passin...