DSXchange

DS Server, 6.0r3 on SUN ----------------------- I am trying to turn the following record into a 'table' using the CFF stage: ------- 4a0123c ------- The fields are: Field d, dec (1) - the 4 Field a, char(1) - the 'a' Field b, char(1) - the '0,1,2,3', occurs up to 4 times, depends on field 'd'. Field...

Hi. I have a an odbc connection defined in my uvodbc.config file: DBMSTYPE = ODBC network = TCP/IP service = unix06 host = 1.0.0.0 When I go to Manager-->Import Table Defns-->ODBC Table Defns, 'database1' shows up in the DSN drop down box. When I try to use the ODBC stage, 'database1' does NOT show ...

Sorry, I do not have much experience with Axcel Path. Which version of DS did you install?

- BP

DS Server 6.0r3 on Sun.

When I load a Table Definition into the sequential file stage, the 'format options' defined for the table are not set within the seq file stage. Is this a bug? Or do I need to set a flag that tells DS to also import the format options too?

Thanks,
BP

Well, I guess it WOULD be helpful if ASC provided the full documentation for PX. [;)] Maybe you could post the rtypes for those that do not have the upcoming manual. If I were doing what you have to do, I would use buildop. Buildop would allow you to keep your data in parallel. You want to avoid unn...

MAT, You are doing three things: 1. Using column generator (sequentially? or in parallel? Parallel will not work) to generate a unique row id. 2. Using a transformer to add the ID column the current ID number 3. Adding x to the CurID and move on the next incoming data file. Which part specifically i...

MAT, The rtypes are listed in the documentation. I don't remember what rtype values are, but one might be 'roundzero' or 'trunc'. I *think* rtype is an ENUM that stands for the type of rounding value. It seems like you should be able to be able to use the func w/o the rtype though. To see if buggy c...

OSH or PX GUI?

I'm pretty sure it is possible to do what you want in PX, but I don't remember how. For the time being, you can cheat by going into the OSH Script and using regular sh commands to access env vars.

- BP

Does this mean that the COBOL field properties that I set, such as 'occurs' etc, are not really processed by DS Server jobs? Ultimately, I am trying to find a good way to get a DS Server job to read COBOL data with occurs statements correctly. Any ideas?

DS 6.0r3 on Solaris -------------------- Here's what I do: 1. Import a COBOL File Def via Designer 2. Load the imported file def into a Sequential File stage 3. Double click on a row in the 'columns' tab on the Sequential File Stage 4. Try to click on the 'COBOL' tab in the Edit Column Meta Data Win...

From the code generated from a DS Sequencer job, there is the line:

*****
msg$ = DSMakeMsg("DSTAGE_JSG_M_0001Error calling DSAttachJob(%1)%2", jb$2:@FM:DSGetLastErrorMsg())
*****

What does the '' mean?

TIA,
BP

DS Server 6.0r3 on Solaris ------------ I'm looking at the code generated by a Sequencer job. The following lines are in the code ******************* L$23$START: *** Activity "ExecuteCommand_10": Execute command p$23$1 = "" x$cmd = "echo job2 is done >> tempfile":"...

Does anyone have a list of all the conversion codes for OConv and IConv? Particularly, I'm trying to find the conversion codes for TimeStamp and Time, but I'd like to see all of the codes.

Thanks,
BP

I think that the PXEngine dir is linked to the other PXEngine dir. When you run a PX GUI job, you see Environment Variable Settings in the job log. You'll see a couple of relevant environment variables including: PATH APT_CONFIG_FILE APT_ORCHHOME LIBPATH (or something like that) The settings for the...

Well, you can do it thru the PX GUI, if you like. Just link a input dataset to a 'copy' stage. Then link the 'copy' stage to the output dataset. Compile and run! To run the osh script, you would need to type: osh "copy < in.ds > out.ds" at the command line. This will only work if your envi...