Search found 84 matches

by Xpert
Wed Sep 20, 2006 3:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding the SIze of Flat file
Replies: 15
Views: 5199

DSGetLinkInfo() requires four arguments; a handle to the job (DSJ.ME may be used), the name of the stage, the name of the link and an integer specifying what information about the link is required to ... Hi, Syntax - DSGetLinkInfo (JobHandle, StageName, LinkName, InfoType) As ray said, last one is ...
by Xpert
Wed Sep 20, 2006 12:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date format conversion: YYYY-MM-DD to YYYYMMDD
Replies: 3
Views: 5576

Hi,

You can use DIGITS(DSLink3.Date), it works fine than Oconv and Iconv conversion.
by Xpert
Wed Sep 20, 2006 12:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding the SIze of Flat file
Replies: 15
Views: 5199

Hi BoppanaKrishna,

You can use DSGetLinkInfo function to get the count of records in source file.
by Xpert
Tue Sep 19, 2006 11:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file size exceeds cache size
Replies: 4
Views: 3784

ray.wurlod wrote:(1) ANALYZE.FILE hashedfilename STATISTICS
Hi Ray,

Did this command, works for Type -25(B-Tree).
by Xpert
Tue Sep 19, 2006 10:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to capture bad format rejects
Replies: 5
Views: 1400

meena wrote:Hi
If you mean rejects from the sequential file then 'NO'.
Hi,

Meena is right. In server Jobs, we cant able to capture the reject records at source level. But In Parallel Jobs, we can do.
by Xpert
Tue Sep 19, 2006 10:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem With ExecCommand Activity
Replies: 4
Views: 2289

Hi,

As earlier replied message, give ur path as parameter and pass to the Execute Command activity in Job sequence, it will work fine.
by Xpert
Tue Sep 19, 2006 1:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installation Problem
Replies: 3
Views: 1530

Probably the connection was refused or the RPC daemon (service) is not running. Did you check? Is port number 31538 open in the firewall? Do you have service pack 2 installed? If so, have yo ... Hi, Do u mean DSRPC services? If so, it is running, but if i start DS telnet services, its starting and ...
by Xpert
Mon Sep 18, 2006 11:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installation Problem
Replies: 3
Views: 1530

Installation Problem

Hi, I have installation problem. I installed DS ver 7.5 on windows XP both server and client in same system, but its not connecting to server. Its giving the following Error Message. " The connection was refused or the RPC daemon is not running (81016)" Please tell me, whats the reason for...
by Xpert
Thu Sep 14, 2006 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extracting excel file
Replies: 4
Views: 1291

hi

you can use ODBC stage or Sequential file stage. If you are using sequential file, then first convert excel file to CSV format and then extract that CSV file.
by Xpert
Wed Sep 13, 2006 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 7.5 problem
Replies: 10
Views: 2667

Xpert, you really are confused. The original poster did specify Windows, but it's 7.5x2 (not 7.5.2) that supports parallel job compilation and execution on Windows. And please don't use SMS- ... Hi ray, Please see the original poster's version he mentioned and in which OS, he is using. Thats why I ...
by Xpert
Wed Sep 13, 2006 2:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: diff b/w DSLinkrowcount & DSJ.LINKROWCOUNT
Replies: 4
Views: 2637

diff b/w DSLinkrowcount & DSJ.LINKROWCOUNT

Hi,

Pls clarify my doubt. whats the difference between DSLinkrowcount & DSJ.LINKROWCOUNT.

Thnx in Advance
by Xpert
Tue Sep 12, 2006 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 7.5 problem
Replies: 10
Views: 2667

Hi,

First of all, which version u r using and in which platform, because i was confused on seeing ur version and platform. Because here people told that 7.5.2 only runs on windows platform.... pls clarify this.....
by Xpert
Tue Sep 12, 2006 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to capture the warnings
Replies: 4
Views: 1555

Hi, I tried with DSGetLogSummary function, but its giving newest log only. but i want to capture all the warnings. Thanks in Advance. I think you can do this by using DSGetLogSummary U wil need to write a routine and use the function DSGetLogSummary, the result of which you can store or write to a f...
by Xpert
Tue Sep 12, 2006 4:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to capture the warnings
Replies: 4
Views: 1555

How to capture the warnings

Hi,

I want to capture the warning messages and i have to load it in a table. if the warning is because of truncation errors, unique constraint, whatever it is? How to capture those warnings?
by Xpert
Thu Sep 07, 2006 5:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executing Two dos commands in Execute Command Activity
Replies: 12
Views: 4706

Xpert wrote:
kumar_s wrote:move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter# ...
Here we are hardcoding the date value by passing parameter. how to use DSJobStartDate in this condition.