DSXchange

I guess you can recognise null values in such a file, when you find a zero length string between two TABs. In this case, I suggest to insert a transformer stage between your file and odbc stage, put your condition (say: IsNull(Field01) Or IsNull(Field02) and so on) in one of the output links, and ma...

:o Many thanks for your suggestion, I will try as soon as possible. The form you suggest sounds new to me in user-defined SQL statements, I only knew it as Ascential self-generated code. However, I did not expect it could work when used as user-defined statement, and I did not find it anywhere in th...

As my licence has not been renewed yet, I cannot access at the code at the moment. So we both must trust my memory. However code has the following form: INSERT INTO ds.dbo.Sheet (CustCode, JobCode, SrcFileName, SrcPath, TrgFileName, TrgPath, PostDate, SysTs, AcqDate, CustID, PrnLnName, DivName, JobI...

all: Thank you for your suggestions. Now I am waiting for DS licence renewal, then I will be able to try to apply them. Roy: Using a view is an interesting work-around: I will try it. Handling myself the identity column has not worked in any way: Insert row failed is the nicest error I get. :roll: ...

Hi Larry, mine is not an assistance... just a thought. The tfmop_functions.h file on my system DOES contain the prototype of u_print_warning method of the class APT_TOFunctions. I am working on version EE 7.5 for Windows, but the maintenance log of the header file does not show any change related to...

OK, thanx.
I'll try to follow your suggestions.
Reg's

Hi Arnd,and thank you for your quick reply. Yes, I thought about something similar, my stage variable is ready to accept the value you mean and it would be glad to do it, but that poor variable itself cannot figure out how to retrieve the SQL-generated identity value. :wink: In addition, identity co...

Hi all, I am new to DataStage, and the following is my current scenario: 1) My input is a sequential file; 2) A transformer stage extracts info from the file's header, that are to be stored in an SQL Server table with an identity column called SheetID; 3) The file body contains records that are to b...