DSXchange

Siva,

I have already stated that "yes, it is possible". Since you still haven't answered the question as to what database you are using nobody can help you much further. The DS/BASIC routine will contain calls to DSExecute() that will do the actual SQL setup and insert to the database.

Achhh, thanks for correcting me, I typed too fast and didn't check what I'd written. I won't go back and correct the post, but the line should read

"You can use single quotes, double quotes and the backslash quote character in the same job"

What tool did you use to generate that display?

Have you checked your physical and virtual memory and seen to your paging space?

SYSTEM RUNNING OUT OF PAGING SPACE

Explicitly convert your timestamp into a numeric format using SecondsSinceFromTimestamp and some starting timestamp and then use the aggregator to get the maximum. You can then reconvert this back to a timestamp format after the aggregation.

You can use single quotes, double quotes and the ampersand quote character in the same job.

Get a replacement CD from IBM or try one of those magical cleaner kit things (I've never had any luck with them, but did once use some very fine fiberglass polish to get a music CD working again)

yes, there is a limit. Check your data size using "ulimit", this will give you the upper bound. Subtract one or two Mb to be on the safe side and you have your limit. Most likely you will have no limit on data, so assume that your maximum string size is going to be around 2Gb minus a couple of megab...

Could it be a bad CD drive? Try to read it on another PC, if it works then copy the files to some network drive.

Try copying the CD to a local folder to see if you get any media errors. If not, try installing from the local copy to see if the error remains.

Try putting in a reject link to see if there is a data problem, or try doing a manual insert into SQL Server 2000 of one of your data rows.

Depending upon your configuration, this might start off quite a few processes on your machine in a very short period of time. Assuming a 4-way APT_CONFIG file you will have something like 38 pids starting and processing your data and all of them will be writing to the same disk locations for the dat...

It is possible to do this, although it is seldom a good idea to circumvent the fast and efficient loading methods in DS. Usually the easiest method is to use your databases' command line calls for inserts and updates. The actual commands you use depend upon your OS, DataBase system and DB version. T...

Try using the "SEARCH" facility, it is of great help in many cases when the problem is one that others might have had.

The easiest way is to use an external call, i.e. "wc -l" to get this information on UNIX or on Windows with something like MKS toolkit installed.

Are you installing from a network location or from the installation CD? I wonder if the error is coming from a network transfer problem, as the message "Datatransfer error" is an odd one.

Jobs are initiated from the DataStage server machine using the "dsjob" command. If you can issue this command then you can run a job. The .NET doesn't come into it at all.