DSXchange

All, I have create a job which will extract the data from a table and store it in a text file. say for example, Table Name: Emp I want to add current date at the end of file. i.e if i run the job now, the file should be created as e_details20090701.txt suppose if i run the job tomorrow,then the file...

I changed it to SYBCTLIB. It is working fine now.

how to clear the table before running the job?

will it be done automatically?

or do we have to call any stored procedure internally?

After i changed the client library from MSDBLIB to SYBDBLIB

i got the below error message.

BCP..Sybase_BCP_Load_1: Bulk copy failed. Client does not have the capability to bulk copy into the data-only locked table 'acs..Perf'.

All, I need to move PROD data into DEV & QA on every night. There are around 8 tables which i need to move. Each of them have around 600000 records. I used sybase OC to move data to DEV & QA. I used 'clear table then insert rows' option, it is nothing but, 'Truncate and then insert' which wi...

How to move hash file content to a temporary table?

ArndW wrote:Look at my query again, what about the "fund_dt < getdate()" part? ...

Nothing that much diffference. 53247608

ArndW wrote:That isn't too large a number, why not use that query, then do a hashed file lookup in a transform stage instead of copying the hashed file to a db table? ...

select count(*) from nv = 53287608
select count(*) from nv where fund_id in (select managerid from #temp) = 50000

ArndW wrote:Yes, you could load the hashed file into a temporary table. That would entail moving less rows from the database to DataStage. How many rows get returned with just "select count(*) from nv where fund_ ...

It is around 50000 records.

I tested this process manually like

where fund_id in (1,4,8,1001,5778,84449)

The query executed within 10 seconds. Thats why i want to implement the logic

where fund_id in (select managerid from #temp)

All,

How to understand a sequencer job? I have seen so many Sequencer jobs in my project.

All, I have created two jobs. Job:1 It will extract some set of data from a table and store it in a HASH file. ServerA.(managerid->column name) -->Transformer --> Hashfile ( 1700 rows) Job:2 It will fetch the fund_id from a table which has 5M records for the given date(say for example 15/jun/2009), ...

ray.wurlod wrote:Look in the DSINCLUDE/JOBCONTROL.H file in any project, search for the token DSJE. BADSTATE (which equates to error code -2). This indicates that the job is (was) not in a runnable state - perhaps no ...

From where i have to find it?

can you tell me the exact location?

ray.wurlod wrote:Who or what sent the email? Track that down. ...

Actually we schedule the jobs,i received it from that email id. I already posted the content of the email. Just i got the above error message only.

All, 5377\2009-05-29 21:02:20\2\\295\P_S06_TO_PS_MA_SL..JobControl (@S07_MA_SL): Controller problem: Error calling DSRunJob(P_S07_MA_SL_HG_DATA), code=-2 (...) 5380\2009-05-29 21:02:20\2\\295\Attempting to Cleanup after ABORT raised in stage P_S06_TO_PS_MA_SL..JobControl 5379\2009-05-29 21:02:20\3\\...

Could you post the resolution, please? That and marking your post as Resolved would be helpful as well. ... Sure... The table has some datetime columns. I used 'Date' datatype for those columns in Sequential File Stage & SybaseOC stage. The text file looks like 20090529 Since it was varchar,i g...