DSXchange

Can I complicate this further?? :oops: I have a similar situation where I need to compile around 2000 jobs. We use a distributed environment, so there are no client installs on our individual development machines. Instead, we access the development tools through Citrix (v4 I think). Any ideas on tha...

Can I complicate this further?? :oops: I have a similar situation where I need to compile around 2000 jobs. We use a distributed environment, so there are no client installs on our individual development machines. Instead, we access the development tools through Citrix (v4 I think). Any ideas on tha...

Sorry, I've only gotten to work with Server so I can't speak to what Parallel can do. I'm assuming there is functionality there for it, but I would not be a good source for it. I know there are plenty of other gurus on this site who can though. Give it a few hours and someone will take a shot at it....

Welcome to DSXchange! My blind shot in the dark (since there isn't more information to work with) is that you do not have the System DSN set up correctly. Give us some more info including the text of the error message(s) so we can provide more assistance. Please note the 'Code' button just above the...

Welcome to DSXchange! My blind shot in the dark (since there isn't more information to work with) is that you do not have the System DSN set up correctly. Give us some more info including the text of the error message(s) so we can provide more assistance. Please note the 'Code' button just above the...

Take a look at Ken Bland's job control process and code. You can download it from free from his website (which I can't remember off the top of my head right now). Sign up for his free membership and go download the utilities and documentation he makes available there. In it you will find exactly wha...

Strictly due to ignorance on my part. :oops: I'm not very familiar with routines and coding in DS Basic yet. I have yet to get something to work correctly (I'm working on one right now for a project). So, depending on the deadline I had to meet, I would sometimes have no choice but to use what I kne...

Thanks, Gents!

I appreciate the replies and look forward to seeing how it works on a really large set. I'm interested because I have a similar issue on one of the teams I work with and I'm wondering how best to address it.

Bestest!

Hey Datastager, Just out of curiosity: how long is it taking the code Ray provided for you to order the information for you? I know I have added this code to my collection of interesting bits and I'm just wondering how it compares to an external call using sed, awk or Perl. As usual, Ray Rocks! Best...

Perl is also quite fast for this type of activity and a little less cryptic (in my humble opinion).

Bestest!

We definitely need more info, as Havoc said. I am doing similar things, but would need to know general table layout structure to see how you are doing it. The way I do it now is to populate the additional fields I use for historical tracking and current row recognition during the transfer process, t...

Great! Thanks for the clarification Craig. That makes perfect sense because as long as the target field is numeric, then the leading zeroes would just drop off during datatype conversion.

Bestest!

Quick question, Ray:

If he treats it as a VARCHAR, aren't the numbers going to be ordered lexically as opposed to numerically. To me, it seems that is what the original example looks like.

Bestest!

Hi all, I recently posted a bunch of my Perl utilities I have written. One of them will take a single DSX file and split each component part out into their own file. I did this for Release Management and external code versioning that we use at my company. If I remember correctly, it will also split ...

Welcome aboard! hi bala go to help page or better go to data stage manual u have with example that wht we r doing Please remember: with many of the people accessing this site who are not native English speakers, it is vitally important to NOT use abbreviated language (such as 'u' instead of 'you' an...