DSXchange

laknar

Andy is correct .
If the job parameter is "REPORT_DATE" then how is the value of "ReportDate" being derived?

laknar

Specify Record Delimiter= UNIX New Line or the file may be in DOS Format

laknar

this seams that ReportDate parameter is not specified for that job.
check the job parameters , the parameter name should be the ReportDate name.

laknar

your problem may be in last line.
check whether the last line contains new line character or line feed.

laknar

use substring function to extract

Code: Select all

decimalcolumn[1,11]:".":decimalcolumn[12,2]

laknar

why don't use the funnel stage
give union option there

laknar

hashed file stage remove duplicate data based on key value.
there will be count mismatch on the data flow. we need to avoid the hashed file as source.

laknar

select DATE('given_date') +1 month -day(DATE('given_date')) as lastday from tablename

laknar

Go to the columns tab and right click the column properties go to edit row specify the field length for each column. you can give the start position. after setting the property run the job again

laknar

From next stage extract the filename from the full path.

Code: Select all

Field(Filenamecolumn:'/','/',4)

laknar

Sorry

Code: Select all

IF IsNull(ColumnA) Then '0' Else If (ColumnA='O13' or ColumnA='S10' or Trim(ColumnA='')) Then ColumnA Else '0'

laknar

Stage Variable1 ------------------------- IF IsNull(ColumnA) Then '0' Else If (ColumnA='O13' or ColumnA='S10' ) and ColumnB>0 Then ColumnB Else '0' Stage Variable2 ------------------------- IF IsNull(ColumnA) Then '0' Else If (ColumnA='O13' or ColumnA='S10' or Trim(ColumnA='')) Else '0' Have Constra...

laknar

If source is a file. definitely this will be the file issue.

can you please post the source file format and job design. And do you have any constraints in transformer stage.

laknar

Read the column as varchar then

Code: Select all

If IsNull(columnname) then @NULL Else If Num(columnname)=0 Then Convert('a','0',columnname) Else columnname

laknar

check if there is any firewall.that may prevent client connections to server.

install the datastage client in local
give prvileage to developers to access the datastage server through remote client.

Search found 162 matches