Hi all,
i need to create import scripts or create export scripts based on some specific condition.

for example : I have the table Employee(Empid,Empname,DepId)

Here i need create export script/create import script for the employee who is
having depid 10
Where i need to write this kind of condition.
Expecting reply soon.

Thanks in advance,
Uma.

In session tuxch0131m000(Maintain Table Relations) form 2 condition.

thanks for reply , Can you tell me How i need to write condition in the form 2 of tuxch0131m00 and wat i need mention in type and domain.



Thanks,
Uma.

Basically you just create a condition script first. You have it return true or false based off the input record - false will not load the record and true will. You can run help on the condition session to get more information.

Well here is a sample condition script in one of our exchange scripts:

domain tpptc.seqn m.sern
domain tcyesno tflag
select tipgc020.*
from tipgc020
where tipgc020._index1 = {:orno, :pono}

selectdo
tflag = tcyesno.yes
selectempty
tflag = tcyesno.no
endselect
if tflag = tcyesno.yes then
return(true)
else
return(false)
endif

Thanks again

Now wat is my doubt is where i need to write this condtion script. help me ASAP.

Thanks & Regards,
Uma

Use session tuxch0114m000 to create condition scripts. Use the session help or download some documentation from Infor support site.

Hi

I wrote script just like as u suggested but i am getting the while creation of import scripts. i am sending the screen shot in attachment. Plz help me


Regards,
Uma.

Sorry i for got the attachment

unresolved reference to function exec.cond.tfacp901.suno


i having tfacp901 table with suno(string) field as primary key.

suno
-----
1001
1002
1003

My aim is to export only the first record from this table.

Help me.


Regards,
Uma.

After adding the condition did you re-compile the exchange scheme?