DSXchange

You would be able to see the db2 loader's log file on the unix box where your db2 server resides. You can get the path from the config file in which dbnodes are defined.

Hi All, I am facing problems while reading excel file in Datastage Px in Unix environment. I have tried doing it using sequential file stage, but it is not able to read the data. If am I converting it into csv file (manually) then I am able to do read it. But we will be getting pleanty of such sourc...

Hi,
I think you need to put the data from cycle 1 jobs into a binary file instead of a dataset and then read that file using CFF once again by giving the correct layout of the filler column.


Thanks

Let us know what have you provided in the lookup failure option in the lookup stage.

It all depends on data, while data in production environments are relatively larger so you never know that is it because of data or code that the job is failing.


Anand.

yes you can easily control the sorting order in an ETL job. You can use sort stage for sorting as well as retaining the last record. But before that you need to know which record comes in the last. Consider and example: EMPLOYEE_NO DEPT_ID 117514 123 117514 456 Now you have to see which record you n...

Hi naren, before you could login to the designer you need to create a user. Please follow below steps: 1) Login to Information server (http://localhost:9080) and go to the administration tab. 2) Then go to User and Groups drop down and select users. 3) On the right side click on new user and give al...

Type http://localhost:9080 and check that you are getting Information Server loin page. If it fails to show then check that below services are running or not: 1) IBM Websphere Application Server V6---- 2) All the Db2 related services if the meta server is installed on DB2. Just check and revert Than...

Type http://localhost:9080 and check that you are getting Information Server loin page. If it fails to show then check that below services are running or not: 1) IBM Websphere Application Server V6---- 2) All the Db2 related services if the meta server is installed on DB2. Just check and revert Than...

Hi Ray,
Thanks for your suggestion. Transformer is geting compiled correctly

Ray,
Thanks for your reply. One quick question, am I correct in installing the mentioned SDK and iniitiating the LIB and INCLUDE environment variables???

Hi I have installed Information server V 8.1 on Windows XP. We got C++ software litle late a as such installed Microsoft Visual Studio 2005 after installing Datastage server. Now server is running fine but the compiler is giving issue and transformer is not getting compiled. According to the documen...

Can you be more clear on what you are doing with SEQ2. Is it a different sequence with jobs associated different from that of SEQ1 or it too contains the same associated jobs as SEQ1??

Post the Fatal error which you are getting in the log when the job aborts. This will make it clear what is happening.

Hi I am trying to view the data from CFF stage, but getting below error :- "Input buffer overrun at field "FIELD NAME" , at offset:26 Here are the details of my job - Source file is - Mainframe file having COBOL definition. File Format - VBS (variable blocked spanned) Record length - ...

Hi Ray, Thanks for you reply. The value for one field defined as PIC X; on the mainframe side it is hexadecimal value coming as below: ########################## <blank> <blank> a j e f ########################## The records like a,j,e,f are getting correctly read from the mainframe side but the <ba...