DSXchange

I don't care what database it is, updates are always relatively slower. Pretend you are the database server and think through the amount of work that has to be done to perform an update compared to the amount of work it takes to do an insert. With and without indexing on the key column(s). This is n...

What formats? What does "are wrong" mean? In DataStage/SQL you can override default formats with field qualifiers such as FMT, COL.HDG and so on. So it should not be too much of a stretch to get that right. If you're talking about date formats you may need to convert CURRENT_DATE to extern...

Server job?!!

Why not just create another configuration file by choosing "Save As" from the Configuration File editor?

ERROR
Full parameter filename = /
(fatal error from A): Error opening parameters file, '/', status = 2

You can't use OpenSeq to open / because / is a directory not a file.

The reason is that I am a "premium poster" but you have not (yet) purchased a premium membership. Read this page for information about membership benefits. Premium memberships are one of the mechanisms used to fund the ongoing hosting and bandwidth costs of DSXchange. Without such funding ...

DTM is a VarChar(19). That's why you can not compare it to CURRENT_DATE, which is a Date. DataStage/SQL does not have a Timestamp data type. You could CAST the leftmost ten characters as DATE or CAST CURRENT_DATE as VARCHARto effect the comparison. CAST(SUBSTRING(DTM FROM 1 FOR 10) AS DATE) = CURREN...

Moderator: please move to server forum

If this is actually a parallel job, then getting the partitioning wrong might be a contributing cause.

Include the keyword NOPAGE in your query. If you are using SQL, place NOPAGE after all the "regular" SQL clauses but ahead of the terminating semi-colon.

NO.PAGE is a synonym for NOPAGE.

Not true. If the job aborts they get 3. If it finishes with warnings they get 2. If they used -mode RESET they get 21. And so on.

LIST.READU from the Administrator client. Each connected client has a lock of the form projectname!&DS.ADMIN&! From the operating system on the server you can use ${DSHOME}/bin/list_readu (which is the same command) and pipe the output through grep to isolate just those entries containing DS...

That's probably most easily done by pivoting the elements into separate rows, processing those rows, then pivoting back into a single string. Otherwise you're up for a custom routine or BuildOp containing appropriate internal looping.

The Exception Handler has three activity variables that may help at the sequence level. Otherwise, create a routine that reads the job log. Any operator that raises an error will name itself in the logged event. Be aware, however, that operator combination will lead to the operator being reported in...

Sorting is specified on input links, not on output links.

All a sequence is is a GUI that generates a job control routine (which you can inspect in the job properties window). Sequences are preferred for anyone who is not an expert (and I use that term in its strongest sense) in the DataStage BASIC programming language and in using the DataStage API.

I have Got a reqrmnt that ... For ex: ... Tx for the help in advance... Welcome aboard. Please invest in more vowels. We try to maintain a professional standard of written English on DSXchange, because there are many whose first language is not English. Even correct English, I'm sure you will agree...