DSXchange

Thanks guys, I tripled-checked the job, and it was indeed type mismatches. I can use the connector directly against the lookup stage - no intermediate stage required. However, with server jobs, I've found I had to insert a hash file stage between the connector & transform, so that's why I was th...

Are there any guidleines for using the Netezza connector directly as a lookup? I'm getting a variety of errors ; - columns not being right type - columns not found , even though they're right there Is it recommended to have a stage (copy, dataset) between the Lookup stage and the Connector stage? I ...

Certainly XMLs seem to be more of a pain; however in our case we are finding it easier to manipulate the XML files (have to do several global changes, using a Visual basic script, then a Linux script). Embedded in a .DSX file are dozens of XML statements which can be several KB in length. These caus...

In the thread "Manully alter DS DSX or XML job exports", they discussed moving XML files into a project, but there was no mention of XML file size. I have a project where the full project exported is > 350mb. Exporting to XML is no problem, but I get errors when I import elsewhere: Run-tim...

Is it possible to use dsjob to get a list of new or changed jobs - say with today's date ? We're trying to automate our project backups using istool, but only want to export it when a change to a job in the project has happened. I know there's a 'modified_date' entry when you export in DSX, but I do...

Found it (among other places) with the keyword CodeBase , under the HKEY_CLASSES_ROOT section. So, you could use the Windows command like : reg query HKCR /s /f codebase > IS.txt then examine IS.txt - if it contains 'InformationServer11', then you're pointing to the 11.5 client. if just 'Information...

We recently added DS 11.5 to our 8.5 versions on our Windows clients. I use Multi-Client-Manager to switch between 8.5 and 11.5 no problem - When I bring up the MCM dialogue, it knows which version I'm currently aligned with. ..... But how does it know? Are there any files at the Windows level that ...

We recently ran into this error when trying to view data on a sequential file stage. Our file was valid, but only had 1 row. For some reason, the 'skip count' in the data browser had been set to 10. I guess the dialogue can't handle a skip greater than the number of rows (However, it seems to be abl...

Yes, if it was tables, I would've tried RCP, but I don't believe that's suitable for CFF stages.

Hi Thanks for the comments. I agree that better communication and a solid process would be the best. Sadly, those requests have not proven effective. So, I'd like to take control of the situation by an automated way. So, I've begun the imports of all the CFF stages that I can see. It's laborious and...

Hi, Is there an elegant way to test the structure of a CFF file? We read in dozens of mainframe files, and the source-side personnel sometimes neglects to tell us that they're changing the structure. Usually, they make the change in the UA environment a few weeks ahead, so instead of our production ...

Thanks.
I guess eliminating the -incexec from the export is the only way...

When importing using Istool, you work with an .isx file. That .isx file can contain source code and/or executable code. When importing, is it possible to import ONLY the source code? I see the [-nodesign] switch can prevent the source code from being imported, but is there a similar switch that woul...

Hi,
I tried doing arithmetic on the decimal(18), but it rounded the number, thereby corrupting it.

Trimming the period away was the solution. I used:
TrimF( Trim(input_stream.Column,'.') )
and that seemed to work.

thanks for the suggestions!

Hi,

Not sure how to convert to raw hex - is it possible in a server job?

In any case, if I search for 45. (in view data) it fails. If I search for 45 (in view data) it succeeds.