DSXchange

girija wrote:Since your first constraint is linkStatsXML.FileType = "FULL" your result may be random, means nowhere in your job you ensure atleast one record with linkStatsXML.FileType = "FULL" should be there in the node 0.

Thanks to both of you. This is now working properly.

I have a parallel job which uses a transform stage. The input to the transform is a XML stage which generates approximately 100000 records. One of the transform outputs (which is ordered currently as the 3rd of 5 links) traps only the first record off partition 0 in order to catch a date field by us...

Thanks, I feared that was the answer. Not terribly useful to have to go get event ids from Director right now.

I am trying to trap the log details from a parallel job. When I issue the command dsjob -logdetail <project> <job_name> The following comes back: Invalid arguments: dsjob -logdetail [-useid] <project> <job|jobid> <first event id> [<last event id>] Status code = -9999 DSJE_DSJOB_ERROR Going into dire...

In Designer, under Table Definitions\XML, DS allows the name of a category to be created to contain a dash (-). However, when an actual XML table import is performed and an attempt is made to save the definition (under the Save Table Definition dialog box) in that category, DS complains about the da...

Thank you - thread is resolved.

dsNovice: The typical error that comes back with improperly using a system variable in a DB2 stage is: <job name>,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009 Unable to connect to DB2 server '#DSCAPIOP__DB2_Server# Where we tried to use #$DB2_Server# as th...

In DS Admin, I have setup a series of parameters, some of which will be passed to a DB2 stage to perform queries or loads. In my job sequence, I bring in all the environment parms I need, and set them all to $PROJDEF, to fill in the value at run time for easier maintenance when changing things in Ad...

I went into admin and turned RCP (new to me) on for our project and recompiled and it worked. I am not going to get into the debate about the pros and cons of RCP.

DS 7.5.2: I have an XML file with some empty fields, a small example without header info follows: <FIELD1></FIELD1> <FIELD2>1234.56</FIELD2> Using the XMLInput stage, I can carry the fields across with no problems by checking the "Replace empty values with NULLS" in the stage properties. A...

The list of functions available in a server transform lags compared to what is available on the parallel transform (example: date artithmetic).

If there is a good technical reason why the function lists can't be the same, please post here.

On the fly training, "here's the software, here are the .pdf files and here is a large project for you to do."

So by experimenting, reading the manuals (somewhat useful) and reading posts here (very useful) since early 2008, I am getting the hang of things.

I will look into this. Too bad DS doesn't have a transpose stage, this is a one step process in SAS with a PROC TRANSPOSE (as of now, that plug in is not installed here, though I am considering asking for it).

If any of the other DS gurus have any ideas, they would be greatly appreciated.

I have an XML file that needs to be transposed: Source: Same Date, Unknown number of Group_Type, Group_Num, approx 2280 records per as shown below. There will always be 13 "stat" columns that will have values or be null (Field_Name is a character field): Date Group_Type Group_Num Field_Nam...

Is there an easy way to determine the number of quarters between two dates which could be added as a column derivation in say, a COPY stage: For example: NQTRS between (2007-03-31 - 2008-03-31) + 1 = 5 (absolute value) Those of you familar with SAS, the code would be NQTRS = INTCK('QTR','31Mar2007'd...