My Oracle Support Banner

Is There Any Option Besides EIM Export Match IN Clause to Export Multiple But Not All Records of a Siebel Table? (Doc ID 2652978.1)

Last updated on MARCH 27, 2020

Applies to:

Siebel CRM - Version 16.19 [IP2016] and later
Information in this document applies to any platform.

Goal

It is necessary to export thousands of attachments from the S_FILE_ATT table. The following ifb file was created:

[Export Attachment]
TYPE = EXPORT
BATCH = 2016
TABLE = EIM_FILE
EXPORT ALL ROWS = FALSE
EXPORT MATCHES = S_FILE_ATT,(ROW_ID IN('1-33YX','1-33Z5','1-33ZF'))

Is there a better solution for this case, so that multiple values are not written using the IN clause?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.