Regarding the SIze of Flat file

boppanakrishna · Post by **boppanakrishna** » Tue Sep 19, 2006 11:22 pm

hi all,
I want know the total number of records in the Sequential file ,my job design is Sequential-->Transformer-->Sequential,My exact question is to find how many rows are there in the source Sequential file..

Thanks in Advance,
Boppana Ramakrishna

Xpert · Post by **Xpert** » Wed Sep 20, 2006 12:20 am

Hi BoppanaKrishna,

You can use DSGetLinkInfo function to get the count of records in source file.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 1:01 am

Do you have MKS Toolkit or some other UNIX emulator available? If so, you can use the command wc -l filename to get the line count.

boppanakrishna · Post by **boppanakrishna** » Wed Sep 20, 2006 1:38 am

Xpert wrote:Hi BoppanaKrishna,

You can use DSGetLinkInfo function to get the count of records in source file.

hi ,
while using that DSLINKINFO it asking to pass 3 arguments ,what should i pass in that ..

Thanks in advance,
Boppana Ramakrishna

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 2:18 am

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 be returned.

DSGetLinkInfo(hJob,Stage,Link,DSJ.LINKROWCOUNT) will return the number of rows passed along the link in the DataStage job. This is not necessarily the same as the number of lines in the source file - it might be constrained within the job or by a filter command.

Xpert · Post by **Xpert** » Wed Sep 20, 2006 3:58 am

ray.wurlod wrote: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 not an integer, its Info type.

InfoType specifies the information required and may be one of these following:

DSJ.LINKLASTERR

DSJ.LINKNAME

DSJ.LINKROWCOUNT

DSJ.LINKSQLSTATE

DSJ.LINKDBMSCODE

DSJ.LINKDESC

DSJ.LINKSTAGE

DSJ.INSTROWCOUNT

DSJ.LINKEOTROWCOUNT

mohanraj · Post by **mohanraj** » Wed Sep 20, 2006 4:16 am

hi Krishna

Do you want to know the number of records in your source file without running the job or after running the job.
If it is for the former one then I don't know,but if it is the later one then you can look for the Xpert suggestion.

mohan

Xpert · Post by **Xpert** » Wed Sep 20, 2006 4:41 am

mohanraj wrote:hi Krishna

Do you want to know the number of records in your source file without running the job or after running the job.
If it is for the former one then I don't know,but if it is the later one then you can look for the Xpert suggestion.

mohan

Hi mohan,

Without running the job, if you want to know the count in source file, as ray said WC -l filename command will help.

boppanakrishna · Post by **boppanakrishna** » Thu Sep 21, 2006 12:27 am

Xpert wrote:
ray.wurlod wrote: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 not an integer, its Info type.

InfoType specifies the information required and may be one of these following:

DSJ.LINKLASTERR

DSJ.LINKNAME

DSJ.LINKROWCOUNT

DSJ.LINKSQLSTATE

DSJ.LINKDBMSCODE

DSJ.LINKDESC

DSJ.LINKSTAGE

DSJ.INSTROWCOUNT

DSJ.LINKEOTROWCOUNT

hi xpert,
Thanks for your reply, Suppose my job name is "sample" and my stage name is "link" and my link name is " Link" and what my question is what should i pass exactly the Fourth argument so that i get the Rowcount
/* i have some but they are not working*/
Thanks In Advance,
Boppana Krishna

Xpert · Post by **Xpert** » Thu Sep 21, 2006 12:48 am

boppanakrishna wrote:
Xpert wrote:
ray.wurlod wrote: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 not an integer, its Info type.

InfoType specifies the information required and may be one of these following:

DSJ.LINKLASTERR

DSJ.LINKNAME

DSJ.LINKROWCOUNT

DSJ.LINKSQLSTATE

DSJ.LINKDBMSCODE

DSJ.LINKDESC

DSJ.LINKSTAGE

DSJ.INSTROWCOUNT

DSJ.LINKEOTROWCOUNT
hi xpert,
Thanks for your reply, Suppose my job name is "sample" and my stage name is "link" and my link name is " Link" and what my question is what should i pass exactly the Fourth argument so that i get the Rowcount
/* i have some but they are not working*/
Thanks In Advance,
Boppana Krishna

Hi BoppanaKrishna,

DSGetLinkInfo("sample","link","Link",DSJ.LINKROWCOUNT)

By this way you have to mention for the source count.

boppanakrishna · Post by **boppanakrishna** » Thu Sep 21, 2006 3:01 am

Xpert wrote:
boppanakrishna wrote:
Xpert wrote: Hi,

Syntax - DSGetLinkInfo (JobHandle, StageName, LinkName, InfoType)

As ray said, last one is not an integer, its Info type.

InfoType specifies the information required and may be one of these following:

DSJ.LINKLASTERR

DSJ.LINKNAME

DSJ.LINKROWCOUNT

DSJ.LINKSQLSTATE

DSJ.LINKDBMSCODE

DSJ.LINKDESC

DSJ.LINKSTAGE

DSJ.INSTROWCOUNT

DSJ.LINKEOTROWCOUNT
hi xpert,
Thanks for your reply, Suppose my job name is "sample" and my stage name is "link" and my link name is " Link" and what my question is what should i pass exactly the Fourth argument so that i get the Rowcount
/* i have some but they are not working*/
Thanks In Advance,
Boppana Krishna
Hi BoppanaKrishna,

DSGetLinkInfo("sample","link","Link",DSJ.LINKROWCOUNT)

By this way you have to mention for the source count.

hi xpert ,
I have used thesame logic given by you, but i am getting the all 0's in to my target column..
My design is : sequential--> Transformer-->Sequential, in the target i have created one extra column which is not there in the source and in the derivation part i have the above logic but it is returening 0's,in the place of stage name what should i specify the outputstage or input stage and same as for the link name also..please clarify this ..

Thanks
Ramakrishna

loveojha2 · Post by **loveojha2** » Thu Sep 21, 2006 3:27 am

DSGetLinkInfo("sample","link","Link",DSJ.LINKROWCOUNT)

Use it in after job subroutine, to make sure that whole job has run completed successfully.

mohanraj · Post by **mohanraj** » Thu Sep 21, 2006 4:21 am

Hi BoppanaKrishna

The Stagename you are specifying should be the active.Try it out once again with this.

Mohan

Xpert · Post by **Xpert** » Thu Sep 21, 2006 4:41 am

mohanraj wrote:Hi BoppanaKrishna

The Stagename you are specifying should be the active.Try it out once again with this.

Mohan

U just change ur layout,

Sequential(Source) -----> Transformer_1 ------> Hashed File ------> Transformer_2---------> Sequential(target).

In Transformer_2 Implement those lines in the derivation part of that target column. you will get the source count. If anything feel free.......

boppanakrishna · Post by **boppanakrishna** » Thu Sep 21, 2006 6:54 am

Xpert wrote:
mohanraj wrote:Hi BoppanaKrishna

The Stagename you are specifying should be the active.Try it out once again with this.

Mohan

U just change ur layout,

Sequential(Source) -----> Transformer_1 ------> Hashed File ------> Transformer_2---------> Sequential(target).

In Transformer_2 Implement those lines in the derivation part of that target column. you will get the source count. If anything feel free.......

hi,
I have tried out your design but it is generating the same..any further suggestion is acceptable

Thanks
Boppana Ramakrishna