DSXchange

I have not used the CFF stage before but now may have an opportunity to. Suppose DataStage is on UNIX, must you first FTP the flat file off the mainframe or how do most people make that communication happen--does the stage fetch the file or assume it's local? Is there a way to map a UNIX file system...

That looks like an Oracle set command and it looks like it's working because the output has the pipe as the column separator. Maybe the problem is that "If a value has more significant digits to the left of the decimal place than are specified in the format, pound signs (#) replace the value.&q...

The new LastRowInGroup() function is in the Parallel Job Dev Guide under Key Break Detection and requires sorted input. I haven't used the new function yet. It sounds similar to but perhaps opposite from the keyChange column from the Sort stage. LastRowInGroup() is true on the last row before the ke...

Did you regenerate the .uvconfig file after changing the uvconfig file?

Hi Ernie, I opened an enhancement request this morning but don't have any estimate when such a security feature could be added to the Console, like ISD project level security. This is somewhat painful to my ears as I have DataStage experience and think the security model works well there, but I'm no...

Thanks, Ray and Ernie, for your feedback. That's good to know that perhaps WAS should remain as a black box. I am wondering because it seems like I need more control over the web service security. Information Server appears to have only one security role for web services, Suite Component role: ISD C...

Hi, I'm fairly new to web services. I have deployed several DataStage 8.5 single node parallel jobs with ISD Input and Output stages as web services using ISD 8.5 and SOAP over HTTP (actually https) with HTTP Basic Authentication. I have a few beginner questions. There seems to be no WAS 7 documents...

Have you tried taking out the "\UIP_ALM" string after the IP address? Here is what a working entry looks like (fake IP) from the ".odbc.ini" file: [ABCMSSQL] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss24.so Description=DataDirect SQL Server Wire Protocol driv...

Oh, that's good. Spend some time going through the product manuals and online help. Your client should have PDF manuals. Look for a parallel job tutorial there.

I really don't have much info. I know for the 3 steps, each one was on a separate physical server. I know IBM was on site with an engineer at the time. XML was just missed/not tested because it wasn't used at the time. The DLL errors are reported from a brand new DS project. I've checked other DS pr...

Have you run the job? If so, maybe all the records were rejected before they reached Seq file 2. The output shows 0 records. You can confirm by looking at the Seq file 2 properties through Windows. What does the OS report as the size of the file in bytes? Do any of the stages have reject links?

I don't think .done is a command but it could be a naming convention someone developed. It sounds like you may have to trace through the jobs and scripts and events that create the trigger files to understand it better.

Thank you!

Have you searched dsxchange for the answer?

viewtopic.php?t=140442&highlight=hexadecimal
viewtopic.php?t=140387&highlight=hexadecimal

Just to be clear (because it's not yet), what is your job design?

Is it like this? ORA --> XFM --> ODBC or ORA --> XFM --> ORA

or FILE --> XFM --> ODBC and ORA, etc.?