DSXchange

you may create a dataset dump using the orchadmin command and do a dump-comparison on operating system level using diff or sdiff.

BR

Werner

Hi,

DS Director is the right place. You have to search for an entry that starts with

"main_program: This step has ... datasets"

BR

Werner

Hi, IS 8.1 on WAS 7.0.x is not supported. You may check the system requirements on the following page: IBM InfoSphere Information Server, Version 8.1, system requirements Pasted from <http://www-01.ibm.com/support/docview.wss?rs=14&uid=swg21315971> ... IBM WebSphere Application Server Version 6....

All, I would like to know the Datastage naming standard for the links as well as for the stages. is there any document available? can anybody refer some useful links or documents? I think the following ibm redbook is a good thing to start with. It was published this summer and was updated recently ...

select Distinct ProviderNumber,substring(printerexception,1,50) as PrinterException from providerpmg,AZ_locations where (PrinterException = 'Mon. - Fri.: 8:00 a.m. - 8:00 p.m.; Sat. - Sun.: 8:00 a.m. - 4:00 p.m.' or PrinterException = 'Sun.-Sat. 9:00 a.m.. - 10:00 p.m.' or PrinterException = 'Urgen...

Hi,

http://www-933.ibm.com/support/fixcentral/
http://www-947.ibm.com/support/entry/po ... general%29

BR


Werner

FYI: Since ntext, text, and image data types marked as deprecated you should try to use different types or consider changing them at the next opportunity For further details refer to the SQL Server 2008 R2 Documentation ntext, text, and image (Transact-SQL) Pasted from <http://msdn.microsoft.com/en-...

Did you cast the fields in the where clause as well. if not please try it.

Note:
(NTEXT/TEXT wont allow any string manipulation (including comparision))

Msg 8163, Level 16, State 3, Line 1 The text, ntext, or image data type cannot be selected as DISTINCT. but i want only distinct records Considering this a SQL Server DBMS you need to cast your ntext column to nvarchar: Select distinct with ntext fields Pasted from <http://social.msdn.microsoft.com...

Hi,

I think a closing quote is missing after 10:00 p.m.

Try changing

or PrinterException like 'Sun.-Sat. 9:00 a.m.. - 10:00 p.m. or

To

or PrinterException like 'Sun.-Sat. 9:00 a.m.. - 10:00 p.m.' or

BR

Werner

If you've double checked the credentials there is a different situation. Just one additional thing that came to my mind: Did you follow really all the steps mentioned in the Fix Pack 1 release notes and installation instructions? An important thing that may have something to do with your issue is th...

Yes Warner,I have already seen that but this command doesn't give you the WAS bit information. Java command just gives you JVM bit information,What I actually looking for is to extract bit information from WAS. if it was a 32bit version of was you would find a 32bit version of ibm jvm in the java/b...

Hi, as far as i know this is a server function and won't work in a PX transformer. possible workarounds are described in this thread: http://www.dsxchange.com/viewtopic.php?t=135221&highlight=oconv by the way i found a 6 year old developerworks post from ray, where he suggested the questioner to...

Hi,

since websphere application server runs as a java process (ibm java is shipped with was), the following statement might be useful as well:

/opt/IBM/WebSphere/AppServer/java/bin/java -version

BR


Werner

what does this info mean process meta data not available in database. If you are running Information Server 8.1 and have not yet installed Fix Pack 1: I found two APAR's regarding this warning and the recommendation for both is to install Information Server 8.1 Fix Pack 1. There is also an environm...