DSXchange

If your source is a sequential file and if ur using server edition, try using "Discard and warn" option in the column metadata.

Thanks a lot guys, I finally got it solved. Used the following approach. say i/p date is of form 105030 (which I get from a JDEdwards sys) . This is different from PX internal Julian date. So I parsed "105" from 105030 and added "1900" to give me "2005". Concatenated 20...

Hi, When I add 1900000 to 105030, it gives me 2005030. The first 4 digits are the years, and the last 3 digits give me the number of days for that year.ie 30 days. so jan 30. So its not a pure Julian Day format I guess. I tried using DateFromJulianDay(2453401) and it gives me the correct date. Now I...

Salil, My input data is of Julian format. Its a integer of size 6. eg. 105030. I have to convert this to a regular date of type yyyy-mm-dd. When using my server julian conversion routine, it gives me 2005-01-30.ie 30th Jan 2005. In the PX developers guide, in Date Functions, they have mentioned this...

Hi all, I was designing a PX job which takes as input a Julian Date for eg. 105030 to a date format eg. 20050130 i.e. convert a Julian date to a date format. I tried using the DateFromJulianDay function in my transformer, and as someone suggested in previous topics, I too got "*********" a...

Thanks guys, I really appreciate it.

The driving issue behind this would be to help decide if I can save up on resources on choosing between 2 approaches.
<1> Having multiple projects within a department.
or
<2> having a single project, but having multiple categories for users within the same department.

Thanks.

Thanks Ray, I appreciate it.

Hi all, I was wondering if it is possible to set category-level permissions in a single project by changing the groups permissions on the RL files created for every job in the unix ascential project directory. What I percieved by taking a look at the RL files in the bin directory was that there were...

Hi, Im getting a datastage phantom saying that REJECTEDCODE previously undefined. The whole body of the phantom is as below. DataStage Job 109 Phantom 4279 Program "JOB.615230357.DT.1372968571.TRANS1": Line 353, Variable "Pin%%V7S4P20.REJECTEDCODE" previously undefined. Zero used...