DSXchange

The design is working as expected

Datatype, length, trim -everything was handled. Could not understand the issue.

The SQL Datatype is 'ntext' (when I see the definition on SQL Server). Whan I import, I get it as LongNVarchar.

I have tried to use Varchar. The job still aborts.

The SQL Datatype is 'ntext' (when I see the definition on SQL Server). Whan I import, I get it as LongNVarchar.

I have tried to use Varchar. The job still aborts.

Hi, I am getting the following error when I try to insert a text field. In Database it is defined as 'ntext'. When I import the table definition, I get it as LongNVarChar(3741823). I am not able to insert record(s) because it shows Fatal Error: Not bounded length when I try to insert a record. Cases...

As far as I know, Column import stage also expects the columns in a fixed position.

Thanks Rob for your response. Some file formats would be: (First Line in each file is column name - please note that all the files will have the similar patterned name and the name will not help in identifying how many columns each file has) 1st example File: A,F1,F2,F3 (Column Names) A1,X1,X2,X3 A2...

Hi, I have a requirement to read a file in the format as below: A,F1,F2,F3 (Comma delimited and column A's position is fixed with 3 columns following column A). 3 is an arbitrary number. It can vary from 1 to 25. So, I do not know the number of fields that will come in the input file. 1) How can I r...

Hi, When I run a job on multiple node (windows 8x DS) and I do a normal lookup. The job aborts stating that lookup failed for the key records, but I see the data in the table when checked manually. The lookup reference is in entire mode and the same job worked fine with more number of records. Input...

I have handled 2 and 3 by using convert(varchar(50),<FieldName>) If that is the DataStage convert() function that's not how it is used. For the 'SQL Varient' can you cast it to its base data type in the select? It is not DataStage convert; it is the SQL variant and the command works. I have used it...

Updates: The job ran fine with 1 record. When 1 try to run the job with 2 records, it aborted with the following error: [Microsoft][SQL Native Client][SQL Server].NET Framework execution was aborted by escalation policy because of out of memory. System.Threading.ThreadAbortException: Thread was bein...

Our job needs to call a UDF through DataStage and the UDF takes 3 parameters that will change based on the input. The UDF returns 0 or more rows for each value passed. We have to take one path if the UDF returns 0 rows and if the UDF returns more than 0 rows, we have to use the values and do some tr...

Thanks for the reply. This issue is resolved. Issue: The main issue was with going to the specific server. Resolution: In the environment I am working, we have a "detour" server and we have to change directory (cd) to a virtual name to go to the specific server I had to ftp. [Used the &quo...

Hi, I am trying to FTP a file to Windows server and faced some issues. FTP Entrprise: I could not give a path on Windows server because windows uses "\" and this stage expects "/". FTP Plug In: I tried using the FTP Plug In stage and I am getting the following error: Connection t...

Sometimes connecting using ODBC stage solves the problem. There were instances where we could not connect to DB2 using DB2 stages, but were able to connect using ODBC stage.