DSXchange

Hi, Our Datastage Server V8.0 on Windows has suddenly got into a mode where it does not get past the login screen. I tried the Designer, Director, Admin and all of them hang while trying to connect/authenticate. This is a newly installed server that was working for a couple of weeks before it ran in...

ray.wurlod wrote:Yes it's possible. The Designer carries the same title whether you run DataStage only, QualityStage only, or both. Licensing affects which stages you can use.

Ray,
You were correct. I just learned that the license is not available for QualityStage.

Thanks for your time and help,

Have you created a new Server job by accident? Hi vmcburney, I am very sure that I created a Parallel Job when trying the QualityStage job. Do you have QualityStage licensed? Hi Ray, I have requested my DS Admin to confirm this once again. The "Program Item" is labelled "Datastage an...

Hi, I am a QualityStage newbie. Recently got access to a Version 8.0 Windows server and tried to work out the "Quality Stage Tutorial" exercises. When I start the Datastage & Quality Stage Designer Client, it starts without any problems. However, after creating a blank Parallel Project...

Thanks a lot for your time and inputs Ray and vmcburney. Appreciate it much. Now I have a fair understanding of what it would take to port the SSIS to Datastage. It is always an interesting challenge when it comes to a deciding what portions are better left to reside in Stored procedures and what sh...

Hi, Has anyone worked on porting SSIS to Datastage? There are certain jobs implemented in SSIS that we have been asked to review and also expand in the short term until we move to Datastage. Is it possible to migrate these SSIS jobs into Datastage in the future or is it better to re-write them to ta...

Hi, Here is my use case. We have several files from various providers on a daily basis. These files arrive at different times of a day. Each of these files has its own pre-defined format, columns that have been documented. Each of these files are parsed and loaded into separate Database tables dedic...

Thanks for the response Ray. I could not find any useful hits on the IBM site. I will forward this to our support group to check with IBM Tech and update the group.

Thanks,

You have these in parallel jobs (Compress and Expand stages). You have this indirectly in job sequences, via the Execute Command activity. I don't believe this request will get very far. Hi Ray, Thanks for the quick followup. Appreciate it much. I didn't realize that the Compress and Expand stages ...

I am not sure about Issue# 1 and you might want to play with the "Format" setting of the file stage. As for validating the input document against an XSD, here is what you should do. 1. Enable the "Validate input XML" checkbox in the "General" page of the "Stage&quo...

Hi, I was wondering if there exists functionality within Datastage to allow down/up loading files from an HTTP server. FTP stage would let one to work with (Up/Down)Loading FTP servers. But if i were to do the same with an HTTP server, is that doable or should i get back to command lines or other sc...

All the other dimensions have the same design. The size of the data is more/less same in each dimension. so we are clueless :oops: Even though you are "Not Allowed" to change the job design, were you able to try a test implementation of this job using "Hash File Lookup"? Sometim...

Hi, In our existing applications we generate different flavors of files (Text, XML) and compress them to Zip, GZ et al and then upload these to FTP sites. Current workaround is to execute the compression scripts (ExecuteSH et al) and then come back to Datastage and continue the job. If we need to in...

Add this to the description in XML stage/ Input/ columns. "/Branches/Branch/@BRCH" Hi, What does this XPath expression do? Is this attribute "BRCH" a part of the xml sample schema/document that "Agnes" is referring to or is this a debugging element in Datastage? What s...

Hi Ultramundane, I have forwarded all the different patch case numbers you provided to our Admin group. Awaiting their responses on the details of these patches and if these will be installed on our server without impacting any other applications that might be on this server. Hope to get a feedback ...