DSXchange

Thanks Chulett, When I say working means Job ran successful but I do not have a detailed log of Stored Procedure after the execution .. Given In Row generator no.of records =1 Fail on Error :Set Option Yes (ODBC connector stage) Below are informational messages in Director logs Odbc_SPCall,0: Number...

Hi Chulett, My account is still Premium account ..Let me explain what I am doing exactly here : 1)Search in Google for some topic ..Open Dsxchange Post (without login to account) while browsing post click Premium content Button 3)Navigate to Login Screen .Entered the credentials then it is Navigate ...

Hi DSXchange Users/Moderators,


When I do a search and look for a post if a post shows as a Premium content (What is it ?) When click it is taking me to home button to login instead showing the content for the particular post ..

Please advise on the usage

Thanks

I tried below design and worked
In ODBC ,Gave user defined SQL :statements
Job ran successful and SP executed .

Thanks

Hi Ray, After the re-run I was able to see the logs (earlier run) and job ran successful . Director logs (Administrator level) set as upto 5 runs .How do I search for all entries in Director ? I tried view >Filter Entries but it is not giving me the entries for last 5 runs / Is there any place Purge...

Thank you for the suggestions on using SP stage ..I would like to test using ODBC connector stage as SP stage is not going to be the option for me as it is advised. I am getting below error when I use the Exec statement in SQL ..Please advice me on the usage ODBC_Conn,0: ODBC function "SQLFetch...

I am using version 8.7 ,Admin is saying SP stage is obsolete and use connector stage .next I am using DataStage to literally Run SP ..Expected value is an integer


Thanks for the suggestions

My Bad its ODBC ..
Thanks

Hi, I am advised to use ODBC connector for SP Execution . Oracle connector ---->Peek Before Sql statements exec schemaname.dbo.TestSP ;commit; What is the SQL statement to use in the Select statement ?Can I use the above statement is SQL section ?What I have to specify in the columns tab ? SQL Serve...

Hi, I am executing a Sql server Stored Procedure (Which returns the Return value -no parameters ) Stored Procedure stage ---->Peek Procedure type :Source Database Procedure type: Stored Procedure Procedure name :TestSP Syntax :exec schemaname.dbo.TestSP Generate Procedure call :Unchecked Job is fail...

Hi , While we are running a multi instance jobs in a Sequence using shell script ..we got the job aborted with following messages DSW_import_Seq.1.JobControl (@Coordinator): Summary of sequence run 04:05:05: Sequence started (checkpointing on) 04:05:05: DSW_Import_Extract (JOB DSW_import_Extract.1) ...

Ray,
It was running fine in 8.5 version and while testing in 11.3 , Job got aborted.
In a Sequential File Stage ,Under NLS map I changed "#NLS#" to project default (UTF-8) ..Job ran Successful

Thanks,
Mahesh

Hi, I am testing a job with Salesforce stage in it and it is giving me a following error Salesforce_conn: Code page in use: UTF-8 FATAL ERROR (APT_CharsetConverterRep::initConv()): #NLS# is not a valid codepage. I checked the NLS params project default utf-8 Please let me know if anyone experienced ...

Thank you for the suggestion ..When I ran the job in stand alone (not in through sequence job)job finished with too many warnings. If there are no data issues ,How can we eliminate these warnings with out making the changes to the jobs ?As we need to make lot of changes the jobs (each job reading ar...

Can you please provide more details from the Director log ?