DSXchange

Hola mis amigos......

I need to generate an *.xls file from within DataStage. The generated file should be accessible from Excel program.

Does anybody know what is the format the file shoud has, in order to be "understandable" for Excel ?

Thanks in advance.

Thanks to everybody who answered this question.

Ray:

I didn't understand what you said in you last note. Do I really need the C compiler for installing the SOA Edition ? And if yes, what level of C compiler ?

Have a good day.

Hi my friends.

I need to know where can I get the hardware and software requirements information, in order to install the SOA edition of IBM DS 7.5.

Thanks in advance.

Thanks for answering.

It was an application problem, because my development and production environments get mixed. So, I thought that the data I was seeing was from production, but really was from development.

Thanks again.

Hi, my friends.... Y have a hash file, and a BASIC routine accessing it. Everything is fine, and suddenly one record is not stored in the hash file. This hash file is fed from a SAP table. There were no changes to the SAP table, no changes to the hash file, no changes related to this small environme...

Ray:

Thank you. It worked fine, but the only thing that I had to change is the beginning of the variable LineCount: I set it to 0 in order to work fine.

Have a nice day.

Hi forumers.......

I need to know if there is an easy way to count how many records are there in a sequential file. And I have to makew this count from within a BASIC job.

Any help will be appreciated.

Thanks in advance.

Hi forumers... I have problems sending a mail from within DS. The mail is sent when all the processes could start without any problem. This is a scheduled process in the Windows Scheduled Tasks screen (an *.bat is invoked). When the user of the scheduled task is an administrator, the mail is sent. W...

Thanks Siva and Ray.

We will make a test in other server, and then we will be migrating.

Anyway, I would like to read some documentation about the last release. Where can I find it ?

I suppose that the SAP connection wroks fine also, isn't it ?

Hi forumers.... I would like to know where can I look for information for migrating my current jobs in release 5.2, to the last release of DataStage. Does anybody know if an inconsistency may exist ? Or should I modify jobs manually before/after migrating to the last release ? Does it exist a docume...

Ken:

I'm sorry, but I really didn't understand what you explained me. Could you give me an example ?

Hi my friends..... I need to make some operations (add, subtract) using days, but I must consider working days and not working days. Does anybody know if there are functions in DS in order to get the "holiday status" of a given date ? And besides, I need this function to take into account ...

Hola mis amigos..... I want to know how can I check if a given object is corresponding to the source with the same name. This is because for accessing SAP, and by security reasons, people from versioning, when I have to make a cutover into production environment, must enter the Designer and modify t...

Thanks Craig.

My only concern was about to leave the VOC in a "good state".

So, with a "DEL" (delete) command and with the "RD" (remove dir) command I can make the cleanup of the directory in which the hash files are allocated. Isn't it ?

:D :D :D :D :D :D :D :D Hola mis amigos.... I need to cleanup temporary hash files that are being created in a specified directory; this is not the project directory . Besides, I already have a routine to delete hash files, but from the project directory. How can I do, to delete hash files from the ...