DSXchange

Deepak,

Why cant you import the job again, so that it will clear all the old entries and create new entries.

Why You want to have it in a comma Seperated Values. Any way you have written a routine to list jobs , so further extend your routine. Loop the output and append it to the same variable Some thing like Ans = "" cmd="SELECT NAME FMT '60L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' SUPPRESS...

All the log files are stored in the project directory as RT_LogXXXX where XXXX is the Job Number. You can get the Job Number from DS_JOBS, but these files cannot be read as normal file. You have to write a utility on your own, to convert those entries to a normal file. Search on this forum , you wil...

You are having an option "Reset If required, then run" in the execution Action, Choose that option. It will reset the job.

Do a Search, You can find So many posts for answering this. One possible solution Your Job metada wont be matching with ur oracle table structure.

Try to identify the column which throws this error and increase the size of that column in the job.

I hope the Target lookup Hashed File would have exceeded the Size limit.

What worked? Were the VOC entries each pointing to SDKSequences in the local project? If so, what change(s) did you make? YES , the Voc pointers were not pointing to the common path. I created two new projects . Placed the SDKSequence File at a common path outside the projects. Created VOc pointers...

J_Fact_PS_F_CI_BILLING_FAR..DRS_PS_CI_FAR_BIL_LKP: Client Library property required for stage J_Fact_PS_F_CI_BILLING_FAR.DRS_PS_CI_FAR_BIL_LKP I hope in your DRS Stage, you would have used some job parameters and those parameters may not be defined or doesnt conatain any value in the user defined e...

If the above method is not possible, then the thing comes into my mind is 1) Create a Server Job which will read the data from DWTP_CURRENT_STATUS and write it to a Hashed file 2) Create a routine which will read the value from the Hashed File (Look into Routines/SDK for examples) 3) Use the routine...

Is it possible to do something like joinig the tables in the query itself SELECT FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD5 FROM F0005 WHERE DRUPMJ > (select PRV_LOAD_JULIAN_DT from DWTP_CURRENT_STATUS where condition) AND DRUPMJ <= (select CUR_LOAD_JULIAN_DT from DWTP_CURRENT_STATUS where condition)...

You can assign those values as Job Parameter and use them in ur Source Query.

Create two job parameters PS_START_DT and PS_END_DT and change your quey like

There are some command line utilities like DSExport and DSCmdExport. Search for these words and you can find some posts.

In ADN we are having a batch file which will export all the projects from the server.

I hope Kim Duke's query will help you for finding the table names. SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'Your Table Name',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' FROM...

Hi Reddy Whether You are getting any errors? If not run the job with Array Size 1 and i hope you may get some errors. Still the data is not loaded, then I hope you are having NULL in your data and you are trying to populate that to a Not Nullable Column. Do the Null Handling, Your problem will be so...

Iconv and Oconv can be used for converting dates. You can use something like Use the Search facility for Iconv & Oconv, You can find N number of posts.

Thanks
DS_SUPPORT