FTP COMMANDS

Hi All,

If there is any requirement for transferring files from UNIX to Window shared path and vice versa through FTP,
Please use the below commands for achieving this

UNIX to Windows Shared path:

cd <Local UNIX directory where Input files are available>            
ftp -n <<EOF
            open <FTP Server Name>
            user <FTP User Name> <FTP Password>
            cd <Windows Shared path where you want to copy the files>
            mput <File Name*>
EOF

Windows Shared path to UNIX:

cd < Local UNIX directory where you want to copy the files >
ftp -n <<EOF
            open <FTP Server Name>
            user <FTP User Name> <FTP Password>
            cd  <Windows Shared path where the Input files are available>
            mget <File Name*>
EOF

Best Regards,
Moorthy. G

Load Data Oracle to Ms Access

 MS ACCESS:

==========

1. Open a new Microsoft Access File.

2. Go for option File--> Get External Data -->Import

3. It opens one dialog box.

4. Select Files of type as

"ODBC databases"

5. Select the Machine Data Source.

6. Select the ODBC Driver(DSN) which is capable of access that required database data. (Then double click on the ODBC)

7. Enter the Password for that connection.

It loads all the data from Oracle to Access.

Step1:

DSN CREATION:

Select Start»Settings»Control Panel»Administrative Tools»Data Sources (ODBC) in Windows 2000/XP or Start»Settings»Control Panel»Data Sources (ODBC) in Windows 9x/Me.

Select either the User DSN or System DSN tab.

Select Add»Microsoft Access Driver (*.mdb)»Finish.

Give it a Data Source Name and a good description.

Choose the Select button in the Database field.

Navigate to the location of your Access database and select OK.

Select OK on the ODBC Microsoft Access Setup window.

You should now see your DSN in the User/System Data Source window.

Informaitca

========

Create a relation connection using odbc driver in Worklflow Manager.

Connection Name: ODBC connection

User Name: pmnulluser

Password: pmnullpasswd

Connection String: NAME of ODBC connecti

How to make reusable transformation into nonreusable transformation?

Reusable transformation into nonreusable transformation
=====================================
1) Drag the reusable transformation from Repository Navigator into Mapping Designer
      by pressing the left button of the mouse
2 ) Then press the Ctrl key before releasing the left button of mouse.
3) Release the left button of mouse.


To Find a CHEK CONSTRATINT in DB2
================================
SELECT
TBNAME,
TBOWNER,
CHECKCONDITION
FROM SYSIBM.SYSCHECKS
WHERE
TBNAME='TABLE_NAME'
AND TBOWNER='SCHEMA'

Best Regards,
Moorthy. G

1. How To Find Primary Key and Foreign Key Relationship in a table in DB2?
Ans:

 SELECT A.CREATOR, A.TBNAME, A.RELNAME, B.COLNAME, B.COLSEQ,
       A.REFTBCREATOR, A.REFTBNAME
  FROM SYSIBM.SYSRELS A, SYSIBM.SYSFOREIGNKEYS B
  WHERE A.CREATOR = 'SOURCE'
  AND B.CREATOR = 'SOURCE'
  AND A.TBNAME = 'TABLE_NAME'
--  AND B.TBNAME = 'PROJ'
  AND A.RELNAME = B.RELNAME
    ORDER BY A.RELNAME, B.COLSEQ

2. How to find index in a Table in DB2?
Ans:
SELECT DISTINCT
A.TBNAME,
B.COLNAME,
A.INDEXSPACE,
A.DBNAME,
A.CLUSTERING,
A.CLUSTERED
FROM SYSIBM.SYSINDEXES A, SYSIBM.SYSKEYS B
WHERE
A.CREATOR = 'SOURCE'
AND TBNAME = 'TABLE_NAME'
AND A.NAME =B.IXNAME

Best Regards,
Moorthy. G

STORE PROCEDURES:
==================


COPY TABLE
==========

create or replace procedure table_copy(
  GM_tab_from varchar2,
  GM_tab_to   varchar2)
Is

Begin

  execute immediate 'insert into '||GM_tab_to||' (select * from '||GM_tab_from||')';

End;
/

CREATE_INDEX:
=============

Create or replace procedure CREATE_INDEX

As

Begin

Execute immediate 'create index unconn_dept on SP_UNCONN_EXAMPLE(DEPTNO)';

End;

/

DROP_INDEX:
===========
Create or replace procedure DROP_INDEX

As

Begin

Execute immediate 'drop index unconn_dept';

End;

/

Informatica workflow status  SQL Query

SELECT WORKFLOW_NAME,
SERVER_NAME,
RUN_ERR_CODE,
RUN_ERR_MSG,
SUBJECT_AREA,
decode (RUN_STATUS_CODE,1 , 'Succeeded',
2,'Disabled',
3,'Failed',
4,'Stopped',
5,'Aborted',
6,'Running',
15,'Terminated')  Status
from infa_metadata_schema.REP_WFLOW_RUN
where START_TIME>= sysdate-2 and END_TIME<=sysdate
order by SUBJECT_AREA,WORKFLOW_NAME,RUN_STATUS_CODE;

If file exists then send email with attachment ?

if
 [[ -f $your_file ]]; then uuencode $your_file $your_file|mailx -s "$your_file exists..." your_email_address
fi

Best Regards,
Moorthy. G