If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Always show 8 digit number!!

Started by anjidwh.cognos, 30 Apr 2014 12:47:37 AM

Previous topic - Next topic

anjidwh.cognos

Hi

I am getting 4 digit number from the flat file in one of the column. But how to show always 8 digit number even we get 2 or 3 or 4 digit number.

I have to show 8 digit number in my target table. Can anybody suggest how to achieve this!!

Regards

MFGF

Quote from: anjidwh.cognos on 30 Apr 2014 12:47:37 AM
Hi

I am getting 4 digit number from the flat file in one of the column. But how to show always 8 digit number even we get 2 or 3 or 4 digit number.

I have to show 8 digit number in my target table. Can anybody suggest how to achieve this!!

Regards

What do you mean by "show 8 digit number"? You are writing data to the table, not displaying it? If the column in your target table is defined as a numeric data type it makes no difference whether it is one digit or 8 passing through your build - it will be stored as a number. Can you explain further?

MF.
Meep!

anjidwh.cognos

From the file we are had data for one of the column like below:
customer number
---------------------
00001020
25361523
00001253

Here my question is while I am extraction file into build and write a simple select stmt for file, then values are shown like this.

customer number
---------------------
1020
25361523
1253

But I need complete 8 digit number how the file contains into my build also. Please help me to get out of this.

Regards


MFGF

Quote from: anjidwh.cognos on 01 May 2014 12:54:10 AM
From the file we are had data for one of the column like below:
customer number
---------------------
00001020
25361523
00001253

Here my question is while I am extraction file into build and write a simple select stmt for file, then values are shown like this.

customer number
---------------------
1020
25361523
1253

But I need complete 8 digit number how the file contains into my build also. Please help me to get out of this.

Regards

What is the data type of the column defined as in your text file definition in Data Manager? is it a number of some sort or a char of some sort? How do you want it to be stored in the table you are writing to?

MF.
Meep!