DSXchange

Scope

use NullToEmpty() function.

Scope

go to Director.
select Project menu --> select Print

Select all entries in Range frame and Full details in 'Print what ' frame

check the Print to file and click o.k --give logfilename and click open button to save

Scope

i think your parameter 'BD' datatype is date.change the parameter type to string.

Scope

try this

Code: Select all

select 
          BUSINESS_DATE 

from saggbp2.etl_business_time 

where BUSINESS_DATE in ('#BD#')

pass the value

2008-11-26','2008-11-28','2006-01-01 in the parameter

Scope

check whether the NLS is installed.

Scope

check whether the NLS is installed.

Scope

use function 'NullToEmpty(Region)' to get expect output[/code]

Scope

use function NullToEmpty(Region ) to get expect output

Scope

from your query i have understand one thing

you want separate year from column .you can do this by using function 'YearFromDate()'.

Scope

you can use

Code: Select all

close command = commit;

in option properties

Scope

try to insert without any conversion

Scope

job will insert one record.

we observed record already inserted.

Scope

Job reads from file, aggregate and insert a record in to a table.

our job inserted a record into a table.but for 30 minutes it show in running status.

i have verified there is no deadlock in database.

please help...

Scope

Thank you all for your response. Finally the DatastageTRUE Copy is working in DR server without installation.i can able to view all projects and codes. Follwoing tasks we did; 1) we added dsrpc 31538/tcp # dsrpc RPC daemon to /etc/services . 2) Given 777 Permission to /tmp directory I changing this ...

Scope

Thank you all for your response. Finally the DatastageTRUE Copy is working in DR server without installation.i can able to view all projects and codes. Follwoing tasks we did; 1) we added dsrpc 31538/tcp # dsrpc RPC daemon to /etc/services . 2) Given 777 Permission tp /tmp directory I changing this ...

DSXchange

Search found 59 matches

Job running for long time