DSXchange

Can you tell us how you have defined your Xpath?

Also, I'm not sure but for me it seems like your XML doesnt have the namespace in the right place. And check whether all your columns are defined in your xsd.

I dont have anyother information yet. It is still in the design phase and I was asked whether datastage supports these kind of files.

Hi All,

Is it possible to read .tot and .dbf file in datastage either in server or in parallel? I have never came across those files. Your suggestions will be highly appreciated.

Thanks in Advance!

I had the same exact error, which was due to an incorrect constrain. I corrected that and never had the issue again. This may not be relevent, but that's what I did.

What is the column that you have defined as key?

Cant we simply use the constrain tab in the CFF? I dont have access to parallel jobs in 7.5. But I believe that should definetly be there. I'm sure we have it in 7.5 server.

Also, If we can use a filer or a transformer, we can do the same in the constrains tab as well.

Am I missing something here?

Do you know the exact length of the record? If so as suggested earlier you can read it in a single column. And if you are not sure about the record length and if you are sure you have a line terminator, you can define a column like varchar 999 and read it as a delimited file with '000' in the delimi...

Yes, there are two If Else conditions in the first transformer. IF NOT(ISNULL(LnkIn.XXXX.YYYY)) Then 1 Else 0 IF NOT(ISNULL(LnkInXXXX.YYYY)) Then LnkInXXXX.ZZZZ Else 'Undefined' No other transformations. Also, no transformations in the rest of two transformers. Its direct mapping. These are not com...

Hi everyone , i recheked again .i had defined the Keys properly but still getting the same error. The same 0 rows are showing. Thanks in advance What are the keys you have defined? Can you post some sample values from your driver and a matching row in the lookup? Also, Check for spaces in the value...

chulett wrote:

arunkumarmm wrote:Any thoughts on using a ODBC stage to write the target file?

Using the text drivers? No clue how well that would work but might be worth experimenting with. If you give that a try, let us know.

I'm trying on that. Will let you know.

Any thoughts on using a ODBC stage to write the target file?

If that's your requirement, yes. One other 'trick' you can try is to increase the size of the fields defined in the job so they are larger than your target field sizes which would allow those 'oversized' values to actually be sent to your database. It should then do an actual physical reject of the...

They won't be rejected but simply truncated. You'll need to check the field sizes yourself and use an explicit constraint to move them down your 'reject' link. Thanks Craig. But I have 2000+ columns and not sure on which columns will be affected. Should I need to include all the columns in the cons...

Yes, delimiter in Field should only be one character. Or you can simply replace ^^^ with @FM and use @FM as your delimiter

Hi, I have a simple job, XML as source and sequential file as target with a transformer in between. Now, due to some extrodinary situations, the source records may have values more than the length assigned in the target stage. This is very rare but can occur. My requirement is to capture those recor...