DSXchange

We went and forced the delimiter at the column level, but still no idea why it is/was generating overall OSH like that when we never set it at the column level in the first place.

Hi, This problem is for DataStage v8.1 on Windows. We have randomly run into a problem for whcih nobody can explain within the last day. I have really boiled it down to DataStage generating some incorrect OSH. For the last 1.5 years, I have been reading in text files in sequential stages with double...

Is there a Ctrl-Z character in your data? (This is the Windows end-of-file marker.) ... I think this ultimately ended up being the reason. Thanks. I opened the sequential file in a hex editor and noticed a 1A (in Hex) character in a field in the 30th record (and also other places). Thanks again.

ray.wurlod wrote:View Data runs through an options window that allows you to limit the number of rows returned. Is yours set to 30? ...

Nope. I set it to 250, then went way ahead and set it to 5000. Same results across the board.

Only when there is a metadata mismatch between the viewing stage and the actual data. Any chance there's "something wrong" with the rows that don't show up when you compare the column definitions to the actual data? I had thought of that too because it's definitely happened to me before. ...

Has anybody run into anything like this?

Interesting. Personally, we use the DB2 UDB API stage to insert data into tables. Not sure if this is what you're referring to, but with that I usually have another message associated telling me (when I click on its details) the values of the insert.

Marley777 wrote:There are no records in the log giving us a hint to which record is the duplicate. Has anyone else experienced this? What did you do to fix?

You're sure? I encounter this quite a bit and there is always a separate warning message associated with each of these.

In my experience, for each of these errors you're getting, there should be another error/warning right under it. Right click and go to Detail on that. it should give you a list of all the values involved in the insert statement.

My datastage has been acting weird of late. I'm wondering if anybody else has run into something similar. I have a Flow that reads in numerous data tables via ODBC and puts them into their own data sets on the hard drive. I noticed that when I do a View Data now on a data set stage, a table which ha...

Hello,

I am trying to use file patterns for the first time with the sequential file stage. I am using a file pattern such as "C:\folder\*.txt" for my pattern, but I get an "invalid hostname C" error.

What's the problem here?


Thanks.

Hello, I was wondering if it is at all possible to "detect" a filename from an input stage such as a Complex Flat File Stage? For example, if I am reading in three files: "records2000.csv", "records2001.csv", and "records2002.csv" from a Complex Flat File Stag...

No, they don't. What does it actually say when you validate? And I don't believe I've ever seen an official grammar reference. Others may know. :? ... I didn't do it because I already corrected it with the correct usage of parentheses. They should really include the BNF for these functions somewhere

chulett wrote:What does it not like about it? Right-click on the red derivation and select 'Validate Derivation'. ...

I think it's because any expressions in that need to be in parentheses. Is there any documentation with actual grammar rules?

Search returned nothing for this, so I thought I'd ask. How does one do Nested If-Then-Else in a Transformer Stage for PX?

I am doing something like this:
If expr1 Then expr2 ELSE IF expr3 THEN expr4 ELSE expr5


of course, DataStage PX doesn't like that..