You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » regarding the usage of tDBSQLRows
Post a reply
Topic review (newest first)
- deepakkr
- 2007-04-06 08:51:27
Thanks for your reply. Atlast i have got the results. The problem is due to the whitespaces in the table entries.
- plegall
- 2007-04-05 10:59:47
The exact same job should work with TOS 1.1.2, I just work on the development version.
- deepakkr
- 2007-04-05 10:42:47
hi
i am using talend Version: V1.1.1. I have tried with the version M3 its working fine. But i want to attain the result using the Version: V1.1.1. How can i achieve?
- plegall
- 2007-03-28 17:46:35
I've used TOS 2.0.0M3 to design the job example.
The "trick" is in the tFileList, where I use fill the "Directory" property with:
Code:
$tMysqlInput_1[0]
Code:
[pierrick@plegall] ~/temp/200703/20070328/topic443
$ tree
.
|-- 01
| |-- a.txt
| `-- b.txt
`-- 02
`-- a.txt
2 directories, 3 files
[pierrick@plegall] ~/temp/200703/20070328/topic443
$ mysql --user=root --password=conway talend
mysql> select * from topic443;
+-------------------------------------------------+
| dirname |
+-------------------------------------------------+
| /home/pierrick/temp/200703/20070328/topic443/01 |
| /home/pierrick/temp/200703/20070328/topic443/02 |
+-------------------------------------------------+
2 rows in set (0.00 sec)The job output is:
Code:
Starting job topic443 at 17:38 28/03/2007. /home/pierrick/temp/200703/20070328/topic443/01/a.txt a|b|c|d e|f|g|h /home/pierrick/temp/200703/20070328/topic443/01/b.txt i|j|k|l m|n|o|p /home/pierrick/temp/200703/20070328/topic443/02/a.txt q|r|s|t u|v|w|x Job topic443 ended at 17:38 28/03/2007. [exit code=0]
- deepakkr
- 2007-03-28 07:29:59
hi,
i am new to the JasperETL tool, i have got a list of directory name in the table. i am trying to read a set of files from the directories. But i dont know how to give the name of the directory to tFileList component as input. If any body have tried this method, please let me. i have tried using the tDBSQLRows,but i dont know how to retrieve the value from the component tDBSQLRows as input to tFileList.
regards,
deepak