DSXchange

Try to reboot the Computer first only client and if that doesn't work also Server.

Try to devide into two parts. Write from sequential via lookups and complicated transforms to another sequential file and then load this file directly to DB2.

If you open MS-Word in Windows you have the application open. In this application you can open several documents.

Word is you database.
Each document is an instance.

MS-Access is a tool in the Windows environment. If you want to use MS-Access in Unix you have to use text-format or switch to a Unix-Database.

normaly the one you select is excecuted. If you make a column-based one the statement is basis for change in user-defined. Sometimes you have some strange behaviours. If you switch from user-defined to column best is to delete the user defined one. If you use user-defined best is also to delete deri...

Hi Lavanya,

if you know what you have already loaded and find a rule where to restart you can do it.

You can also change your job and use the target as lookup and don't reload those rows you have already loaded.

Best is to analyse why your job stopped and to prevent this in future.

maybe that to mask or not to mask or to convert or not to convert is the hash files problem...

Try to change the field-names "TIMESTAMP" and "TIME " as fieldname make my stomach turn a bid.

Use "ErrorTimeStamp" and "ErrorTime" and tell if it helped.

I don't see the real problem!

You might use Stage Variables:
If LEN(TRIM(abc.Value3))=0 THEN 'EAD' ELSE abc.Value3
If LEN(TRIM(abc.Value4))=0 THEN space(1) ELSE abc.Value4

seems easy to me, with basic DS-knowhow.

Your EBCDIC is allready transfered to ASCII so use this function: FUNCTION SwitchEBCDICSign(Arg1) Laenge=len(Arg1) Links=Arg1[1,Laenge-1] Hyro=SEQ(Arg1[1]) BEGIN CASE CASE Hyro >= 65 AND Hyro <= 73; Ans=(Links:Hyro-64)+0 CASE Hyro >= 74 AND Hyro <= 82; Ans=(Links:Hyro-73)*-1 CASE Hyro=249 ; Ans=(Li...

Read Manual or help file, there are plenty such functions, sometime you have even a choice between many functions.

If you have a Windows Server, yes you can install a client and schedule it on your server. For a Unix-Server there is no Client Tool, but you can nevertheless install and schedule the product on any Windows PC or Server. The program does only work correctly if no Jobs are locked (whether somebody ha...

And now the add-on for the specialists:

What about holidays?

How to integrate the gauss Easter rule and all holidays like "Mardi gras" which are derivated from that, and all other holiday falling on non-Weekend-Days.

Your db2 Administrator can solve the problem, they have to catalogue it. It is no easy task. We had the same problem and there was some try and error but finaly they succeeded. If they are ready you can test it on the unix command line. If it works DataStage will work also.

In Version 7 you have this feature already in the product implemented. CompileAll is a third party tool from the provider of this forum. There is also compilewitch and the commandlinetool dsmove as third party tools which can do this job also.

There is no debugger, you to do it the traditional way and use inline command. The Print does a bit of help