DSXchange

I need to implement the above requirement of calling SQL queries using a server routine. I'm aware of the routine ExecDOS and ExecSH which could call a batch file which in turn can call a script file but in this case the errors aren't detected. Is there a routine that can execute an SQL statement ta...

Cheers Ray. Found the directory and file. Surprisingly the file has not been modified in more than a month. On opening the directory however I see two files DATA.30 and OVER.30 which have been modified today morning which is normal since I opened the project today. Permissions don't seem to have cha...

ray.wurlod wrote:Has someone deleted or changed the permissions on DS_AUDIT or D_DS_AUDIT in your project?

Do you see this problem in any other project? ...

All other projects are fine. Just one. How do i check for permissions in DS_AUDIT or D_DS_AUDIT? I'll check right away. Please let me know

Regards

This is a serious problem. Since this morning I can't seem to open Datastage at all. Even in Datastage Manager I can't view all the jobs in a category because of the recurrent message "Cannot open file DS_AUDIT"

Urgent help would be appreciated.

Regards

Hi, I have worked with XML in DataStage, but we havent used the 'validate' option in that. You can use the Validate XML option available in XML Input stage. The invalid records can be captured using a reject link. you can request for XSD from your XML source team or there are lot of tools to genera...

The problem is my files are stored on a remote server accessible by FTP. i thus wrote an FTP program to transfer all the files to my local machine since i can't launch a DIR command on a remote machine. Now I see that all the files have been copied alright but the date and time have changed to the t...

Cheers Craig but how do I implement this in Datastage. I mean i can write a batch file and call it from Datastage which would give a selection of files sorted in reverse order but how do I direct the latest file to another location using a Datastage job?

Regards

I need to be able to copy a particular file from a folder in which a large number of files having a common prefix is present. These files are transferred by FTP and the only difference in the filenames are that there is a number as suffix which is incremented. I need to copy the most recent file to ...

Cheers for that. As i have never worked with XML files I am lost. Thus I'm not too sure about the command line procedure that you are referring to. As for validating text files I'd need to validate that each line that I read contains the required number of columns, the required separator etc. Even i...

I have this assignment where I have as input many kinds of files such as XML, Flat etc. I have to validate these before converting them to flat files in order to integrate the data within into another system. I have thought about doing this by first converting all the files to text files since valid...

Problem solved people.
As I found out the job was just creating the data file to be inserted by the NEXT job in the chain.

I guess in my haste and anxiety I didn't think about this possibility.
Thanks a lot Craig and apologies once again ArndW for this unnecessary thread.

True. 5.2 is painfully old. However I have to work with it since that's what my client is using.
As for the Bulk stage I do not see the option Manual/ Automatic. At the same time it doesn't insert any data.

Can I assume that in Datastage 5.2 this stage works only in the manual mode?

S. Basu, it seems that you didn't look into the sticky readme which suggests using the search facility and the general recommendation that this forum is staffed by volunteers - if you need urgent and qualified instant help you will need to go to your support provider - provided you have purchased s...

Hi all, I am in need of urgent help regarding the Oracle BulkLoader stage in Datastage 5.2 The online help states that: The Orabulk stage is a plug-in stage supplied by Ascential. It generates control and data files for bulk loading into a single table on an Oracle target database. The files are sui...