DSXchange

Rafidwh, I didn't see you mention anything about reading a flat file in this post, but later on I saw the error message that you were unable to view a flat file. Do as Ray suggested and see if the permissions are correct. Go into a UNIX shell and see if you can do a cat of the file with the same use...

Kirtikumar, when changing a sequential file, it is better to create a copy than to edit the original. After the new file is written you can delete the original and rename the new file if you wish. Here is some code that will do what you want, add error handling to your taste and since I just typed i...

Hello Rafidfwh, it is a bit like me saying "When I turn my car engine on there is a red light. What is my problem"? No quite as bad in your case. Is the execution of a job causing this or something else? What does your job do (read or write to/from a database, and if so, which one and how, use any s...

Venu, when you say your jobs "hang", do you mean that they start and have a status of "running" in the DataStage Director? I can see no reason why a job would behave differently because of the time it was scheduled. On UNIX when you schedule jobs to run from the Director they will be put into the de...

Hemant, you haven't confronted any file writing limitations in DataStage routines in this case. When you OPENSEQ a sequential file the file pointer is positioned at the beginning of the file. If you start writing to the file then you are going to overwrite your data and then truncate it when you clo...

Carter,

Thanks!! I'll install it at work tomorrow and use that until the answer comes from IBM/Ascential.

Craig, to convert from an 32 bit integer number to a "packed" 4 byte number the basic method that I used in a function is: ** (c) 2005 AWussing WorkString = OCONV(CRC32(InString),'MB') IF LEN(WorkString)<>32 THEN WorkString = STR('0',32-LEN(WorkString))...

Craig, the answer comes as a 32-bit digit, so the displayed value is going to chew up a lot of spaces, what I meant is that this can be compressed into 4 bytes using a MBOC conversion. I have a routine here somewhere that does that {it also makes sure that no @FM is in the string, so that it can be ...

Madhusv, this is a different problem altogether. Your error is (I think) occurring when doing a view-data or an import of metadata. I assume that you are getting other data types loaded in correctly? Remember that an oracle timestamp is different from a DB/2 timestamp. Please post your response in a...

Rajeev, the restrictions on Windows are only regarding the Parallel Extender package and have nothing to do with operations of Server. You have posted your question in the Server forum so you should not have to worry about limited functionality when installing. PX, on the other hand, will have limit...

(1) This is not a FAQ, please post it in the correct forum (2) Nothing in this forum is urgent; at least not to anybody but the poster. Urgent and critical issues need to be raised with your support provider, they are paid to respond to problems like this. The forum is a loose agglomeration of volun...

Srinagesh, actually, that is a really good solution. I was so concentrated on the string 'compression' function that the (now obvious) table-based solution that you have come up with completely escaped me. With th lookup file you could use a shorter key as well - just start with 1 and work upwards f...

Craig, the job ran through without a collision on all permutations of a 10-character string using CRC32. I just realized that this is not guarantee that it won't get a duplicate on a 9 or 11 length string - but the chances of a collision using 12 CRC32'd number on a 200 character string string are s...

Prabu, If I want to force inserts and not use the bulk load process, I will choose the options 'update then insert' or 'insert then update' and afterwards choose 'custom sql' for both; then I'll cut-and-paste one to the other, so that both actually do the update or insert. But if you only have inser...

Doesn't clicking on the column attribute 'column contains embedded terminators' take care of this problem?