DSXchange

Hello Guys, I am trying to generate file in DS which is compatable with SQL Server 2008 (UTF NLS Code page) , tried with UTF (8,16,32(diff types)) code pages at stage level, not not able to load to SQL Server , Erroring out with below message: Bulk load: DataFileType was incorrectly specified as wid...

hi ray,

Thanks for the quick response.My input data type is decimal (18 ) and I have specified the output as varchar.

Can any one tell me how to handle the thousand separetor in PX we can acheive this in server using the ocon v function.

example:

Input

19945476

required output

19,945,476

Can any one help me out on how to genarate a report during the job run. for example source >>>>trasformer>>>>>sequential file source: emp table target: sequential file emp_id,name,sal 101,p,200 102,c,300 while running the job it should generate a report in such a way header employee details emp_id,n...

Is It possible to set the e-mail notification to two user ata time ?

the time taken to exec the store proc at sql server is approximately 9 min but when i call through DS it takes more time dont know what is happening at the back end.

if it is a DS job then it shows where we went wrong but for store proc there is no info.

if i exec the store procedure it is running fine and getting the expected resuld but when i try to call the store procedure it is in running state not throwing any error msg. CREATE PROCEDURE [DBO].[POLICY_LOAD] AS CREATE TABLE #UPDATEROWS ( [POLICY_NBR_ID] [char] (8) NOT NULL , [POLICY_FORM_CD] [c...

Hi ray,

if i call other store procedure through datastage it is succesful how come this.since evry thing runs under same server.

no i dont have before_job_subroutine call,

only this one is causing problem.

I am calling a store procedure through ODBC stage when i run the JOb the status of the job is showing as running state. when i looked the status it states that the job start date is not there in the director.what might be the cause for this problem. i mannually executed the store procedure it is exe...

hi ray,narasimha

l the same job if i run in the testing environment it is succesful when i try to run in the other environment IA(integration acceptance) it is taking such a klong time.

currently in ST (system test) for the job run it is taking 15 min to complete

hi narasimha,

as you said i executed the store procedure.It is running succesfully and executed with in 10 min.

regards
arasan

Hi ray,

yes i replied upon what i see in the director the job is still in running state.
for this issue isolation level may be the cause just geusing?

database used is SQL server,

stage used is ODBC,

sorce and the target tdata base is same.I am not using more then one job.

We are involved in test run for 2007.one of the job normally in production it takes 1 hr time to complete the job.Now it is taking more time almost 24 hrs this job is in running state and it is not throwing any error message. Job details: the store procedure is called in the datastage designer to lo...