Search results for query: *

Hi Kkecia, I assume that your question means you after the max date and sequence for a date within a date range. If you use the default effdt/effseq sub queries, then the query will not work for you as that only allows for a single date for the max. You need to create your own sub queries in...

Hi egstatus, You are doing nothing wrong - you have the core of the sql correct. There is probably a far more elegant way to do this, but you could try something like this (totally untested) SELECT X.CORR_EMPRESA , X.NOMBRE_EMPRESA , MAX(X.ENE) AS ENE , MAX(X.FEB) AS FEB , MAX(X.MAR) AS MAR ...

Just an update - Change your datatype to a DT_STR length 10 ISNULL(BLOOM_ISSUE_DT) ? "1900-01-01" : (DT_STR,10,1250)(BLOOM_ISSUE_DT) This will set null dates to your 1900 date, the string convert looks at first 10 characters and uses the ANSI code page 1250 for character set decode - but...

Hi, The issue is that you are trying to trim and change case on a date time field. You need to cast/convert the date time to a char field before you can change the format. I am not sure what you were trying to achieve with making a date in uppercase? If you are looking at trimming the...

What is the field length of the destination column? Sounds like you have exceed that limit with the concatenated values in your derived column. You will need whatever length the BLOOM_COUNTRY column was + the appended length of BLOOMBERG. To see the error, set the redirect on for truncation...

Hi, Assume this one is also using the derived column stage. There is a pick list of the expressions when you build the derived column which should serve as a start point - but they are sometimes a little confusing. Your example does not provide an opt out clause where RTG_SP and RTG_MOODY do...

Without seeing your data types, the derived expression will be something like: ISS_COUNTRY =="" ? "BLOOMBERG" + BLOOM_COUNTRY : ISS_COUNTRY Just depends on your database and how you handle blank or nulls against the ISS_COUNTRY column May need to be ISNULL( ISS_COUNTRY) ? "BLOOMBERG" +...

Thanks for the feedback so far. Looks like it is a BIOS issue. Seems to be trying to default to a vga driver on start. Only problem is that I can rarely get it to start consistently to get in and change it. Also without ever achieving 2 successful boots in a row, I am not keen to try flashing...

Hi, Any help would be appreciated. I have a netbook (Toshiba NB305 Windows 7). It stopped booting a few weeks back. On startup, machine powers, HDD starts reading then nothing - however fan still runs, keys light up etc. I tried the usual restarts, battery out, reset RAM etc. No avail. On...

I think your question may be too broad. Data bandwidth is more than likely related to network traffic rather than anything on the database. You can probably provide some data based on the client statistics based on some of the sql being passed. You will need to identify some common or long...

Hi, In your not exists subquery, you should not be slecting any columns. Remove the selected field (B.EMPLID ) and instead create a join criteria on the B.EMPLID = A.EMPLID in the subquery. That should work.

Hi Nancy, One of the joys of PSQuery. Outer joins do not work well when you need max effdt/effseq subqueries on the outer join table. Probably the simplest way to do this is leave the current query in place (or convert it to an inner join) and add a union and return the rows from the...

You could go 'slightly' easier with: SELECT CURRENT DATE - 1 MONTH - DAY(CURRENT DATE)DAYS + 12 DAYS FROM SYSIBM.SYSDUMMY1 Which at least keeps everything as a date through the calculation.... but gets you the same result.

You can delete the max effdt/sequence criteria as it serves no purpose against this table/materialised view.

Hi commish252, Do you need to use JOB? Are you running the employees refresh process - if so PS_EMPLOYEES will have the current snapshot for all active employees removing the need for the effective date logic.

What are you trying to do this in - a report, query, building a new table? Is it a one-off?

Hi Sid, Divide by zero can be handled in the cube - and you can choose the default display of them. In analysis studio Use "Settings", "Data Format" and this will allow you to change the display of most error types. Hope that helps.

Hi tcimis, You are absolutely right with the 2 Job "C" tables. I only have a version 7 PeopleSoft running on DB2 using Australian date format - so writing the code freehand in notepad without testing. Sorry about that. I see you did not go with the lazy DEPT_ENTRY_DATE option ;-) OK...

I see my deliberate mistake ;-) I wrote this from job perspective - whereas employees already resolves the current deptid. Modified code below. What I am guessing is happening is that you have not converted the date format to 'YYYY-MM-DD'. SO what is happening is that it is finding the max...

Hi TCMIS, This kind of thing can be done - but you need to get into writing expressions. If you take the default max effdt and seqeunce logic, then this will basically screw up. What you can do is compare the date and sequence together by creating your own subquery on job. Basic syntax would...