DSXchange

The ixf format is a multiline format, the definitions are freely available on the network and on IBM's web site. I am not sure why you really want to use this format as it isn't necessary for what you want to do - but generate the file for this query and you should only have one data line which you ...

The "continue" means to continue working on the current row, using nulls for the values. This does sound like a potential problem that should be reported to IBM via your support provider. I am still surprised that this could happen, since the variables used for these lookup columns in the generated ...

In you transform you have one input link and (let us assume just 3 maximum) 3 output links. In the constraint for the 2nd one, put "In.a3=>2" and output the row. In the constraint for the third one, put "In.a3=>3" and output the row. This way, if a3 = 3 then for each input row you will get 3 output ...

... (Command was: at -s 19:00 today ) (Data was: /eisetl/Ascential/DataStage/Projects/EIS_MOBILITY/dsr_sched.sh /eisetl/Ascential/DataStage/Projects/EIS_MOBILITY /eisetl/Ascential/DataStage/DSEngine Circle_Bu_Map 0/50/1/0/0 2 >/dev/null 2>&1 And what happens when you try this manually from the ...

Jasper,

links are referred to using LinkName.ColumnName; does this mean that you are specifying Lookup1.D but getting the value of Lookup2.D when Lookup1.D is null?

Mukund - How about doing a first stab at this yourself through looking at the IBM WebSpere ProfileStage pages and then post any remaining questions here? Most people will hesitate to answer such an encompassing list of questions at one go. Arshad - Welcome to DSXchange. If you were to post your ques...

Katz,

I think you've narrowed the problem down to an issue that does need to be reported to IBM support. If you are writing to and reading the named pipe in your DS jobs then wouldn't just specifying no NLS mapping for this pipe be sufficient for your job to run correctly, though?

How about using a transform stage with multiple outputs that have constraints on them so that your data is written multiple times depending on the value of field a3?

Could you post the complete abnormal termination error? And are you certain that doing a reset doesn't give you anything along the lines of a message "from previous run"? Even though the message does come from the &PH& directory, it might have been missed. Or, as an alternative, you could cl...

I think your first step should be to look at the DataStage Developer's Guide and use either "checkpoint" or "restart" as a keyword for a search. This will show you the builtin restartability features in DataStage and will let you work toward writing your own job which handles aborts and re-runs in t...

I'm signed up now as well and can finally see the insides of DeveloperNet too, should I wish to. No more "yes, I use DataStage but don't have my own license... OK, I'll use an email address from my client's domain..."

It does look like a support issue. I'm not at a client where I can test this out but assume that they neglected to put a null handler for the date conversion in and that is why the rows are not being shown. Perhaps someone else here could do a simple test to see if they get the same problem as well.

Does your metadata specify this column as being nullable? I haven't noticed this before but if you have specified this column as being nullable then it does sound like a product bug.

The error cannot, as Ray has already stated, be caused in that line. Unless you are using one of the two argument variables as parameters to some routine which returns them as a file pointer or a subroutine indirection variable. Are you 100% certain that your source and object are in Sync?

The TNS error is a common one when things are misconfigured. Since you are using ODBC on Windows the best, quickest and easiest way to check your system DSN is to use MSQUERY (a free program that comes with Microsoft Office or can be downloaded separately). If you can't connect from MSQUERY then the...