DSXchange

ray.wurlod

How to do incremental loading in datastage in server jobs?
Don't clear the table first.

Is there any difference in loading in server and parallel jobs?
Depends how you design it.

Is there any relationship between incremental loading and scheduling?
Depends how you design it.

ray.wurlod

NO, the User Variables activity goes IN the job sequence. Its variables are accessible only to activities downstream of the User Variables activity.

ray.wurlod

You can effect a SEARCH against DS_JOBOBJECTS, but would then require some knowledge of the structures used in DS_JOBOBJECTS to understand the results.

Code: Select all

SEARCH DS_JOBOBJECTS
STRING=MyString
STRING=
SELECT OBJNAME,OBJIDNO FROM DS_JOBOBJECTS ORDER BY OBJIDNO;

ray.wurlod

Just stick it in user-defined SQL.

Code: Select all

INSERT INTO table(keycol,colA,colB) VALUES (seqname.NEXTVAL,:1,:2);

ray.wurlod

There are Left() and Right() functions available. Using these would make the meaning in your expression pellucid.

ray.wurlod

Two steps. ACCOUNT.FILE.STATS ALL LOCAL SELECT FILENAME.LONG, FILESIZE FROM STAT.FILE WHERE FILENAME.LONG LIKE 'RT_CONFIG%'; Substitute RT_LOG for RT_CONFIG depending on which answer you want. LIST.DICT STAT.FILE to get a listing of other information (column names from the STAT.FILE table) that is a...

ray.wurlod

Try using the APT_string class.

ray.wurlod

You should have the documents; they even ship with server edition. Look for parjdev.pdf and advpx.pdf in your Docs folder.

ray.wurlod

There are many possible reasons, disk space full being one, someone killing processes is another, attempt to divide by zero yet another. It's not possible to tell with just that message? Does it occur reliably? If so, after how many rows? Is there an aberrant row at that point in your source data?

ray.wurlod

For less than US$1 per week you CAN read the whole post.
They do have to fund this site. Premium memberships contribute only a small proportion of the actual running cost.

ray.wurlod

Crikey!

ray.wurlod

You give IBM crores of rupees and they will, at your choice, ship you a CD or provide you with a link to a download site. They will also ship you a licence code, without which you will not be able to get it to work at all.

There is no such thing as version 7.5x.

ray.wurlod

Have you searched the forum? Techniques have been described here before. You can also enrol in the DataStage Best Practices class from IBM.

ray.wurlod

Create a query that constrains on the customer ID and the most recent (probably maximum) surrogate key value via a correlated subquery. SELECT T1.CUSTOMER_KEY FROM CUSTOMER_DIM T1 WHERE CUSTOMER_ID = 'A' AND T1.CUSTOMER_KEY = (SELECT MAX(T2.CUSTOMER_KEY) FROM CUSTOMER_DIM T2 WHERE T1.CUS...

ray.wurlod

A stored procedure is an object in a database. It can be used from various clients and SQL-based tools. "Plug-in" in DataStage means "optionally installed". A plug-in stage can perform any task, not necessarily a database-related task. Some plug-in stages ship with the product, others require additi...

DSXchange

Search found 53125 matches

Warning: Obscure and Arcane Knowledge!