DSXchange

Hi Craig, Actually, I had no idea whatsoever that there was something built in. Once again, my newbie ignorance of the tools shines forth. My main concern at the time was having a three day deadline for moving stuff from a Windoze DS environment to an AIX Unix environment. Not knowing about the 'Bat...

Great! Thanks for the education, Ray.

Bestest,

Leave it to my company to buy the wrong version (wrong being relative of course).

Thanks for getting back to me so soon,

Bestest!

Hi Meena,

Thanks for your input. I will definitely take a gander at it and see if I can apply it for what I need.

Bestest!

See! I told you I'd miss something! I usually run in batch mode so I forgot to include some pattern matching changes I made for dealing with directory structure replacement. The new version is here: #!/usr/local/bin/perl -w ############################################################################...

Hi all! I'm not sure if this is the proper forum for this message, but I figured what I'm putting up here could be used across the different DataStage platforms. We have recently acquired DataStage for our company and we already have seven different teams that have jumped on the development bandwago...

Hi all! One of the many weaknesses of DB2, which I am being forced to move to kicking and screaming, is the lack of functionality to easily generate a checksum() value of some sort. SQL Server 2000 has checksum() and binary_checksum(), my personal favorite that spoiled me rotten for it's speed, but ...

Hi all, I think I've read that Parallel server has some functionality for determining data changes when no update_dt is available. It would sure be nice if this functionality existed in all versions of DS, especially for us lowly Server users :wink: I know there is CRC stuff available, but I would t...

Howdy!

Please forgive my ignorance, but what is "ITAG"? I just want to prevent myself from entering the 'open mouth, move feet freely' mode of life

Bestest!

Hello all! Just because I have not yet gotten to test the usefulness of this feature, is there anything special I have to do in the design process to take advantage of the benefits of multi-instance mode? I guess I'm looking at it from an unload point of view, where I may be unloading a table that h...

Hi I need to create rowid ( sequence numbers) into target table. i am using KeyMgtGetNextValue() function to populate rowid, which is always giving same ids. What my requirement is i need one similat to Informatica's Sequence generater transformation. is there any way we can generate id's like incre...

Hi Deepak, If your transforms have the same input links and output links between different jobs then you could take a couple of different approaches: 1. Use very small jobs that perform specific functions in the job control process. Have this particular task be it's own job with parameterized input ...

Hi all, I have a field in the target table namly row_id integer, which should hold the sequence numbers starting from 1..n for every new record (Insert records). For ex: Are there any builtin functions in Data Stage or any server processings? Please let me know what would be the best approach? Thank...

Howdy! My understanding of the DB2 drivers are that they only display dates in the internal format when using View Data. If you want to see it differently then you would need to convert it using ICONV (I think). Also, you won't be able to do this in View Data of the driver, but you could place a der...

Hello all! We are preparing to implement our DataStage environment on AIX Unix. We have been doing initial development on a Windows server, but our licenses and everything have come through and one of the Unix boxes is done, so here comes the switch. What I am looking for here is any pitfalls we nee...