DSXchange

Once a post has been replied to it cannot be deleted. But I think that our moderator will see these posts and take care of deletions.

If you change your constraint so that no records are being written to DB/2 I think you will see that your read speed stays constant. If not, you need to check with your DB/2 DBA. What stage are you using to write to your DB/2 table and what method are you using (insert, upsert, update)? Is the targe...

The auto purge settings are defaulted from the project level settings but can be overwritten on a per job basis. This might be what has happened in some cases in your installation. I wrote a small routine to overwrite and reset all the settings in a project at this site as they had similar issues an...

Madhu - there is no need to continually post the same question; it has the effect that some people (myself included) just ignore the question and won't post a response.

The log files are only purged according to the settings when a job is run; i.e. if you have a large log file for job ABC it will not get purged until ABC is run again. This is a common cause for using up lots of disk space for some test jobs that were only run once or twice with lots of warnings or ...

Why did you post 2 identical new questions when you already have a current thread on the same error message and same subject? That will not get you any quicker or better answers.

This is the active thread that should be responded to

It would make the code readable if you were to use some indentation. I assume that you meant the routine is working correctly when you test it within the manager but not returning anything in the job. The first thing to do is to put some debugging code into your routine, at least at the beginning. S...

There are many factors that affect the choice of what type of job type to choose. I'll just list 3: 1. Is the rest of the project or even installation done in one type or the other? 2. Is the amount of data to be processed very small, or would it run in a couple of seconds in a server job? 3. Does t...

There is no free or builtin UNIX ODBC driver to read Excel files. You can purchase such drivers - DirectConnect is the vendor that immediately comes to mind.

Vijay - sorry about that, I meant to address my mail to bmadhav. The CFF stage won't make a difference if your metadata is wrong. You need to specify the conversion correctly. Are you using PX or Server?

Vijay, don't you think that copying a premium post in full is not ethical? Also, COBOL fields that are COMP utational and not DISPLAY are the same in ASCII and EBCDIC as they are binary and have nothing to do with character sets. There is no reason to use a CFF stage in this case. There is nothing a...

Ravi,

you will need to explain a bit more about what your problem really is in order for anyone to be able to help you. I assume by "type 2" you mean you are doing a slowly changing dimension in your job. What database? What part of the job is hanging? Is it on the first row?

Your data and metadata are not in synch. I don't know how you have loaded your file's metadata into the repository, but the COMPutational part did not get set correctly. You need to edit the file's definition in the manager (right mouse-click on the column(s) in question, "edit row" and set the data...

I believe that this is a DB/2 instance on a remote machine, for this you will not to add DB/2 node information in your $APT_CONFIG file and set up the access on the remote machine. What does you configuration file look like?

What datatype and format is your date column? If it is a string in the form of yyyy-mm-dd then a simple string comparison will suffice.