DSXchange

Hi All, I have a date field from the input and it's value is 1997-10-20 16:36:51 and type is Varchar(19). Iam trying to load it to a db2 table and the SQL type is TimeStamp(19). I have done the following conversion: StringToTimestamp(<Field_Nmae>,"%yyyy-%mm-%dd %hh:%nn:%ss") Iam getting th...

Hi Chullet,

The file is not too large, it has aprox 1 million records in it.

So, is it something to clear the phantom process to get sufficient resources.

If yes, then how to find phantom process in Windows.

Please suugest.

Many Thanks
Cherry :D

Hi There,

Iam getting the following error message:

ds_seqgetnext: Win32 error in ReadFile - Insufficient system resources exist to complete the requested service

Could some one please help how to get rid of this error message.


Many Thanks
Cherry

Hi All, My source stage is Oracle enterprise. When I try to view data iam getting the following message: The NLS character map <windows-1252> is specified, but NLS_LANG is not set; the NLS character map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG. By...

Hi

The input field type is Varchar8.


Best Regards
Cherry

Hi All, Could some one help me how to get rid of this warning message. My input is a reading from a sequential file and loading to a DB2 table. Input has a field with type of Varchar(8) and Target field type of Date(10). When I do a StringToData(<FieldName>,"%YYYY-%MM-%DD") iam getting the...

Hi All, Could some one help me how to get rid of this warning message. My input is a reading from a sequential file and loading to a DB2 table. Input has a field with type of Varchar(8) and Target field type of Date(10). When I do a StringToData(<FieldName>,"%YYYY-%MM-%DD") iam getting the...

Hi All, Could some one help me how to get rid of this warning message. My input is a reading from a sequential file and loading to a DB2 table. Input has a field with type of Varchar(8) and Target field type of Date(10). When I do a StringToData(<FieldName>,"%YYYY-%MM-%DD") iam getting the...

Hi ArndW,

DSHOME and APT_RESPATH is not listed in the Director log under Enviroinment Variable Settings.


Regards
Cherry

Hi All, Iam trying to Insert the data to a table and Iam using my traget stage as "DB2 UDB Load" Stage. Iam getting the following warning message: Resource bundle corresponding to message key DSTAGE-TODC-00053 not found! Check that DSHOME or APT_RESPATH is set. Could some one help me to kn...

Hi

Add a new field say ERROR to all the three files and assign a default value to identify file name and pull them to reject file link.

Regards
Cherry

Hi All, Could some one help in following design of parallel job. I have the following Columns: Input ------ A B C D 1 878 001 004 1 999 002 003 2 789 005 004 2 996 003 007 My Output should be: GroupBy A and Sum(B) And First(C) and First(D) Output -------- A B C D 1 1877 001 003 2 1785 003 004 Could ...

Hi Everyone, I have the following data: ID_NUMBER KEY 100 AAA 100 BBB from the above data if the ID_NUMBER is same then I have to concate nate KEY values, the output should look like: ID_NUMBER KEY 100 AAABBB. I should get as one record. Could someone help how this can be achieved in Datastage Many ...

Hello Everyone, I have two files AAAA.txt and BBBB.txt I need to have all records from AAAA.txt and Unmatched records from BBBB.txt and I don't want the records from BBBB.txt that matches in AAAA.txt I need to implement the functionality of UNION. Is there any chance that datastage can implement UNI...

Thanks for all the Support. Its working


Regards
Cherry