DSXchange

I am reading the Excel file which is in Datastage server(Unix box), at present I am not having the this Unix access, but the same excel sheet I am having on my desktop.

Please let me know if you need any other information.

Regards
Sri

Hi,

When I am reading the data from Excel sheet by using sequential file stage I am getting the below error
Delimiter for field DB_Office not found

Please let me know what should be the Record level final delimiter, Field Delimiter and Quote values.

Regrds
Sri

Hi,

When I am loading the data into sequential file I am getting below error

Error:No conductor nodes found in export node pool

Please let me know what could be the reason for this error.

Regards
Sridhar

Hi Ray,

Thanks for reply.

Any specific reason why do we need to use extra Execute Command activity in job sequences and more environment variables in Grid environment.

Thanks
Sridhar

Hi,

I wanted to know what precautions we need to take care while developing the jobs in Grid environment.

Any information on how it differs Grid Environment and Normal Environment in development of jobs.

Regards
Sridhar

Hi, SELECT t1.col1, t2.col2 FROM db1@server1:table1 t1, db2@server2:table2 t2 WHERE t1.comm_col = t2.comm_col; This query can be used in Informix database to access tables in different servers, but can we use the same query in a single Inforrmix stage to join two tables in different informix servers...

Hi Arndw, I do not see any difference. below is the data please see. "{CCF998D0-F60C-4211-8E4A-07C420BD64C1}",1,2006-11-09 13:45:31,"erinerinmc@hotmail.com","Erin McElroy","329 Spruce Street 1B","","Philadelphia","PA","19106&...

Thanks ArndW for your response.

I am taking the exact matching number of columns in metadata and file data.

Please let me know, is it because of wrong data in file hence I am getting the below warning.

Thanks ArndW for your response.

I am taking the exact matching number of columns in metadata and file data.

Please let me know, is it because of wrong data in file hence I am getting the below warning.

Hi, We have a job reading the data from .CSV file(Contains 30 million records) through sequential file stage. When we are running this job we are getting the below warning for some records and those records are dropping. seqSVCRegCustomers,0: Field "AFFIL_EMAIL_CNTCT_IND" with 'delim=end' ...

Hi, In one server job having Sequential File ->Sort -> Transformer -> Sequential File stages. When I am running this job it is taking long time and it is showing in running status only(It's not completing) when I abort the job I am getting below error. StgFactAftMgrTillCntdwnAS400_SSNMasking..srtPos...

DSguru2B wrote:You can use the AS_INTEGER() function and then take the length of that.

Thanks DSguru2B.

Hi, My requirement is to find the length of the Decimal datatype column which is coming from source(Sequential file). When I am trying to find the length of this column I am not getting the actual legths, I am getting the datatype length. Example: ABC column, declared as Decimal(15). Value is 103. I...

Maveric wrote:Do an exact search on "Datetime field overflow". See if one of those posts help.

Yes I have done the search, but I did not get the answer.

Thanks.

Hi, I have developed a job with source and targets are SQL Server tables. I am converting some date value columns from Varchar to Date by using StringToTimestamp function in transformer. When I am running this job I am getting below error. APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Serv...