DSXchange

Hi, I have a simple job that goes from an ODBC stage to a transformer then a flat file. I have a user defined SQL: select #$mf_file_pfx1# || REQUEST.F_GET_MF_FILE_EXT ( CHAR(DATE(Current date),ISO), '' ) ||'~' || #$mf_file_pfx2# || REQUEST.F_GET_MF_FILE_EXT ( CHAR(DATE(Current date),ISO), '' ) as mf...

I do this every so often on our Windows servers. Log into your windows server with admin right then... Open a command prompt and cd to D:\IBM\InformationServer\Server\PXEngine\java then execute the following: D:\IBM\InformationServer\Server\PXEngine\java>sh (HIT ENTER) $ APT_ORCHHOME="D:/IBM/In...

This works on windows....I do it ocassionally on our servers when we run into the same issue: Log into the Windows server with admin rights then... Open a command prompt and cd to D:\IBM\InformationServer\Server\PXEngine\java then execute the following: D:\IBM\InformationServer\Server\PXEngine\java>...

Exactly what Craig said.....
Project name is FORM5500 and another job calls this script with the job named passed in as a parameter.
- - John

Hi, As noted in the thread we need bothe the Domain and server parameter when executing via 8.0: Here is teh code we use: D: CD D:\IBM\InformationServer\Server\DSEngine\bin dsjob.exe -domain NJROS1BBLA0705:9080 ^ -user PR-TDSTAGE_ADMIN ^ -password ########## ^ -server NJROS1BBLA0705 ^ -run ^ -jobsta...

After investigating a bit further looks like the developer had the other admin change one of the admin variables for the path (for the file) to include the last "\" before the file name. Not sure what it did but when this was correceted everything is working fine again.
Thanks - - John

I recompiled all the jobs in the sequence as well as the sequnece but the same overwrite issue. I am watching the file on the server when i kick off the sequence and I see that it is created by the first job...goes from 25=>13=>12=>5=>77=>681=>2 to finally 1KB as it passes from the first to the last...

Hi, We have a sequnece that calls multiple jobs and each job after the 1st one appends data to a sequential file created in job1. The developer came by my desk and we we kicked off the sequence and I was on the server watching the file being recreated for every job. Has anyone seen behavior like thi...

Thanks Ray! I did what you suggested and we are now running multiple instances of the sequence and jobs!

Hi, I am working on a new project and setting it up as Allowing Multiple Instances. My question is if all the Sequences and job within a sequence are defined as "Allow Multiple Instance" and we call the Sequence with an invocation ID will that ID be propagated to all the jobs called by the...

Ernie, Once again, i want to thank you for all your advice and suggestions!! With the following changes the Vendor is happy with our output: I have unchecked both "Replace NULLs with empty values" and Replace empty values with NULL's" and removed the designation of "KEY" for...

I ran the extract with the the "replace NULLS with empty values" unchecked and the vendor is specifically pointing to the following situation with our latest extract: Ex: <pruattendees> <attendee/> (If there is an attendee this tag should not be here) <attendee> John Peto </attendee> </pru...

Just wanted to add the following which I just received from our vendor: There are two situations. The first is when there's an extraneous empty tag (which they don't want) and the second when there is no data and an empty tag is appropriate. Examples below: Example 1: <Parent > <Child/> <Child> <Nam...

Hi Ernie, Thanks for all the tips/advice. I have tried your latest suggestion by mapping the input column DSLink2.ActivityTime to the output column activitytime directly in the transformer. I also have the "replace NULLs with empty values" as the only option checked. Looks like now we are ...

Anji, We have just upgraded from version 7.5 to 8.0 our selves and have just started usingthe parameter set From the documentation: - Store a collection of parameters in a named object - One or more values fils can be named and specified - A values file stores values for specified parameters - Value...