DSXchange

Told you I was too dense for this job, unfortunatley I had been doing this by signing on from home, which is limited as I didnt have the manuals.

Worked a treat, thanks for that

Hi, I'm am trying to familiarise myself with PX and have the following problem. 2 files both files 50 records (to keep it easy) CustData (keyed by custid(int) 1-50) CustLoookup (keyed by custid(int) 1-50) PX job 1 load CustLookup into lookup dataset modulas partioned on custid PX job 2 read CUstDate...

Thanks for that, after much playing (not what I told my boss) had come to same conclusion.

Have now got another prob with lookup stage but wont bore u with it as I think I am just being dense (expect post approx 14:00 tomorrow )

Thanks again

Fridge

Hi , I know this subject has been posted before but I still am not getting anywhere so am posting some specifics of my problem so that I can avail myself of your monumental experience and sheer brilliance (you can tell I need help) Basically I am trying to read a csv(ish) file using PX the format is...

Thanks very much for the information Kim and Ray.

Thanks for the help Kim.

Is there anyway to schedule/automate the loading of the access database?

Hi folks. I have been using DS for a couple of months and have only just discovered the Reporting Assistant tool and the corresponding Access DB in the client directory. I am interested in the possibilty of moving this access DB to a shared drive. Besides copying the access DB to the relevant direct...

Ray, Once again thanks for taking the time with this. There will be additional code to this eventually, although it does return what I expect as is (at least when ran as a Transform Function). The aim is, once I have matched the incoming Argument/value 'LinkName' with 'UPCASE (STAGECOM.PIN(PinNo)<PI...

Roy/Ray, Thanks very much for taking the time to help with this. Ray, I will also take on board your point about the use of flags. What I find confusing about this is that I am already trying to use the code within an After-Stage Routine. I therefore thought that as the after-stage routine runs in t...

I have inherited some basic code which I am new to. Essentially it is a transform function that extracts all the fields from a link. I want to do a similar thing but to use it in an After routine. I made the necessary changes so it would run as an After Routine but it fails. It appears to fail at a ...

I am interested in writing some code that would run against a project and tell me which DS jobs update DB2 tables/fields. Looking at the help screens it looks like the function DSGetprojectInfo/Stage Info and DSJ.Joblist is a starting point. Is it possible to identify stages that load DB2 tables and...

Thanks for the help Ogmios/Ketfos. The reason why I need to write a binary zero to a file is because I was intersted in converting a value to pack decimal. My code will work for any value unless one or more bytes contains a binary zero/null. So for example the value 6476 packed returns the correct A...

Thanks for the response - your solution returns an ascii '0' whereas I need to be able to return not 0011 0000 but 0000 0000!

Any ideas?

Suprisingly enough I have tried this! I have a field that when it is a particular value I need to set it to a binary zero and pass it to a flat feed. In DS it appears that @NULL is not a binary zero and when I try to use MY/MB type functions to achieve a binary zero it does not work.

I want to read a binary zero out to a flat file and am having problems.

Does anyone have any information on how to approach this?

Thanks.