DSXchange

Hi Ray, You were right on the spot. I Removed the "Read Only" settings on this folder. Strangely, I did not see the results. I then removed the "Read Only" on the root folder of my client "C:\Program Files\Ascential\DataStage7.5.2". Finally, restarted the "Datastag...

Hi, As I am progressing with different jobs for our requirements, i find myself repeating the initial steps of a job, over and over again. As per best practices & tips on this forum, it is good to have a base/skeleton/template job and reuse it in other jobs. One way to do is to setup a base job,...

2) Under Namespace Declaration, I reference a table definition for the XML. Could you give some more information on how you created the table definition in the first place? Was it using the XML Meta Data Importer and an XSD? How does your XPath expression looks like on the Transformer's description...

output to a file (under option tab) While setting the output file, make sure you select the folder in which you want the output file to be created. If you are comfortable with job parameters, setup a parameter for output file path and one for output file name. Set the OutputFilePath parameter of ty...

Hi,
I am an amateur Datastage guy and I haven't used IConv, OConv so far.... but I recollect from reading the documentation that "Radix Conversions" are possible using IConv, OConv.

Good luck,

Hi DSGuru, Thanks for your time and suggestions. I was held up with some other issue and could not try this out to provide any feedback. I tried a few things and wanted to share here so that anyone who might come searching will get more info (hopefully...) I created a test table and sample data to t...

...If the row count does not matches i need to abend the job.Is there any specific function to achieve this.Please advice. I think Perwezakh has a good point.... Try to gather all details about the requirements... When you say "abend", is it just "end" the job.... and may be abo...

ray.wurlod wrote:It's usually memory. Try not to have too many other things open. ...

Thanks Ray. I will try to keep things at a minimum.
If possible, I will try and see if i can boost my RAM as well.

Thanks,

...each invovles a lookup and update or insert. The lookup table and update/insert table are the same one. Hi, You mentioned lookup in your job. Could you throw some light on this, please? How is the lookup implemented? Are you having a separate instance of the lookup table (as an ODBC stage) and j...

Thanks Craig. So, I am not alone in this planet...:) As you have rightly mentioned, it clears up if i close the designer and launch it again. I didn't have to reboot/restart my machine so far.... Some days everything looks fine.... other days it gets angry pretty soon and gets into this "Plug&q...

Hi Group, When I have my DS Client up and running for a couple of hours, and if i try to add new stages to the job canvas, out of the blue the stage icons turn to a standard "two-outlet electric sockets with a wire and plug". I wish I could upload the image for reference, but I don't have ...

Hi Group, We have been asked to use Datastage Server EE 7.5x2 installed on a Windows 2003 Server box. From various postings on this forum I understand that it is possible to create parallel jobs in this setup. The server is going to be a 4 CPU, 8GB RAM system. I was looking for some performance rela...

The table to which it loads has been created in the database. The job is getting aborted with the error Create External Table Permission denied. Hi Pravin, Your initial statement says the table is already in the database. Are you sure you want your insert process to create the table from the ODBC s...

Hi Ultramundane, Thanks for taking the time to gather all this information. Appreciate it much. I will pass this to our Admin group and see what they gather and let you/group know. Wish they had more descriptions on the fixes related to these patches. DSGuru, Wouldn't that result in loss of data? Bi...

Hi Craig, Thanks for the details. Appreciate it much. I guess i need to work a bit more on handling these log files when things don't go well with the FTP. Our DS job has to notify a support team (email notification) with enough details about the job's status after the FTP is executed. I should, eit...